Guilherme Approbato
Guilherme Approbato
  • 70
  • 217 067
Learn Qlik Sense - How to add fields in the script
This video is part of a course that I plan to gradually post here, so subscribe to learn more about Qlik!
In this video we learn to create new fields in the script - we can't have two fields with the same name in the same table.
Linkedin: www.linkedin.com/in/guilhermeapprobato/
#qlik
มุมมอง: 122

วีดีโอ

Learn Qlik Sense - Rename fields Alias and Add Comments
มุมมอง 15628 วันที่ผ่านมา
This video is part of a course that I plan to gradually post here, so subscribe to learn more about Qlik! This video is an introduction about renaming fields and adding comments in your script Linkedin: www.linkedin.com/in/guilhermeapprobato/ #qlik
Learn Qlik Sense - Introduction about Qlik Script
มุมมอง 113หลายเดือนก่อน
This video is part of a course that I plan to gradually post here, so subscribe to learn more about Qlik! This video is an introduction about script Linkedin: www.linkedin.com/in/guilhermeapprobato/ #qlik
Learn Qlik Sense - The structure of a Qlik Script
มุมมอง 194หลายเดือนก่อน
This video is part of a course that I plan to gradually post here, so subscribe to learn more about Qlik! In this video we understand the structure of the script to load excel tables in Qlik. Linkedin: www.linkedin.com/in/guilhermeapprobato/ #qlik
Learn Qlik Sense - Why and how to unpivot data (using data manager)
มุมมอง 1362 หลายเดือนก่อน
This video is part of a course that I plan to gradually post here, so subscribe to learn more about Qlik! In this video we see why we should manipulate some tables and how to use the Data Manager to unpivot the data. The same result is covered in another video using the Crosstable function. Linkedin: www.linkedin.com/in/guilhermeapprobato/ #qlik
Learn Qlik Sense - Basic customization in your app (color top bar and add thumbnail)
มุมมอง 1292 หลายเดือนก่อน
This video is part of a course that I plan to gradually post here, so subscribe to learn more about Qlik! In this video we see how to add some colors and images to your app Linkedin: www.linkedin.com/in/guilhermeapprobato/ #qlik
Qlik - Reports in HTML in the body of you Email using Qlik Automation
มุมมอง 5272 หลายเดือนก่อน
Qlik Automation can do a lot of things, and here I will share a real case from a customer that wanted charts in his email. Like, subscribe, and tell me your thoughts in the comment section! If you need a writeback tool to edit data, let me know and check out Inphinity at www.myinphinity.com Connect to me on linkedin: www.linkedin.com/in/guilhermeapprobato/ Here is the link to download the HTML ...
Learn Qlik Sense - Using GetSelectedCount to hide and display layers or objects
มุมมอง 1902 หลายเดือนก่อน
This video is part of a course that I plan to gradually post here, so subscribe to learn more about Qlik! In this video we see how to use the GetSelectedCount function with Map layers to hide and display layers. Linkedin: www.linkedin.com/in/guilhermeapprobato/ #qlik
Learn Qlik Sense - Drill Down Dimensions
มุมมอง 1502 หลายเดือนก่อน
This video is part of a course that I plan to gradually post here, so subscribe to learn more about Qlik! In this video we see how to use the Master Items with Dimensions to create a Drill-down (once you select 1 dimension, you go to the next one you defined). Linkedin: www.linkedin.com/in/guilhermeapprobato/ #qlik
Learn Qlik Sense - How to create Maps - Area, Points and Density Layer (heatmap)
มุมมอง 2132 หลายเดือนก่อน
This video is part of a course that I plan to gradually post here, so subscribe to learn more about Qlik! In this video we see how to create Maps in Qlik Sense using the Area Layer, Point Layer and Heatmap (Density Layer). Linkedin: www.linkedin.com/in/guilhermeapprobato/ #qlik
Learn Qlik Sense - Using Master Items in Qlik
มุมมอง 1822 หลายเดือนก่อน
This video is part of a course that I plan to gradually post here, so subscribe to learn more about Qlik! In this video we see how to work with Master Items, saving time when creating or maintaining an app. Linkedin: www.linkedin.com/in/guilhermeapprobato/ #qlik
Criando um sistema no Qlik para inserir dados com Inphinity
มุมมอง 1982 หลายเดือนก่อน
Já pensou em criar um sistema de input de dados no Qlik? Com Inphinity isso e muito mais é possível. Nesse tutorial vemos como fazer um sistema simples de captura de dados. Site Inphinity: myinphinity.com/ Linkedin: www.linkedin.com/in/guilhermeapprobato/
Learn Qlik Sense - The Bar Chart in Qlik
มุมมอง 1592 หลายเดือนก่อน
This video is part of a course that I plan to gradually post here, so subscribe to learn more about Qlik! In this video we see how to work with the Bar Chart in Qlik sense and start analyzing our data Linkedin: www.linkedin.com/in/guilhermeapprobato/ #qlik
Learn Qlik Sense - The Data Manager
มุมมอง 2392 หลายเดือนก่อน
This video is part of a course that I plan to gradually post here, so subscribe to learn more about Qlik! In this video we see how to work with the Qlik Data Manager when we use the "drag and drop" funcionality to import files into Qlik Linkedin: www.linkedin.com/in/guilhermeapprobato/ #qlik
Learn Qlik Sense - Load data from excel (drag and drop file)
มุมมอง 1892 หลายเดือนก่อน
This video is part of a course that I plan to gradually post here, so subscribe to learn more about Qlik! In this video we drag an excel file into Qlik and create some charts to start analyzing the dataset. Linkedin: www.linkedin.com/in/guilhermeapprobato/ Useful links from the video Kaggle Dataset used: www.kaggle.com/datasets/sobhanmoosavi/us-accidents Only 2 years of data: drive.google.com/f...
Learn Qlik Sense - The Qlik Associative Engine
มุมมอง 4693 หลายเดือนก่อน
Learn Qlik Sense - The Qlik Associative Engine
Tutorial Qlik - Mapa de Cidades do Brasil com dados IBGE e Writeback Inphinity (cenários)
มุมมอง 2663 หลายเดือนก่อน
Tutorial Qlik - Mapa de Cidades do Brasil com dados IBGE e Writeback Inphinity (cenários)
How SSE works in Qlik - with Tomas Janco (Inphinity)
มุมมอง 3204 หลายเดือนก่อน
How SSE works in Qlik - with Tomas Janco (Inphinity)
My Qlik Connect 2024!
มุมมอง 2065 หลายเดือนก่อน
My Qlik Connect 2024!
Qlik Sense - Must Know Tips #11 | How Dates work + Master Calendar
มุมมอง 8705 หลายเดือนก่อน
Qlik Sense - Must Know Tips #11 | How Dates work Master Calendar
Chat GPT with Qlik Sense and Inphinity - Exploring Unstructured Data
มุมมอง 7406 หลายเดือนก่อน
Chat GPT with Qlik Sense and Inphinity - Exploring Unstructured Data
How to analyze FAO data with Qlik Sense - Animator object
มุมมอง 3719 หลายเดือนก่อน
How to analyze FAO data with Qlik Sense - Animator object
Qlik & Forms - What you need to know to start now
มุมมอง 93411 หลายเดือนก่อน
Qlik & Forms - What you need to know to start now
Easily automate reports in Qlik Saas - Automation
มุมมอง 2.2Kปีที่แล้ว
Easily automate reports in Qlik Saas - Automation
Create a Writeback solution in Qlik Sense - Easy
มุมมอง 6Kปีที่แล้ว
Create a Writeback solution in Qlik Sense - Easy
Qlik Course, Qlik World and more to come! Sharing some news
มุมมอง 231ปีที่แล้ว
Qlik Course, Qlik World and more to come! Sharing some news
May 2023 - Download and Unlock Qlik Sense Desktop
มุมมอง 9Kปีที่แล้ว
May 2023 - Download and Unlock Qlik Sense Desktop
Qlik Sense - Must Know Tips #10 | Compare column in tables and EXISTS
มุมมอง 4Kปีที่แล้ว
Qlik Sense - Must Know Tips #10 | Compare column in tables and EXISTS
Territory Management Qlik App Demo
มุมมอง 3242 ปีที่แล้ว
Territory Management Qlik App Demo
Qlik Sense - Must Know Tips #9 | Pareto Curve (80-20 rule) and more
มุมมอง 5K2 ปีที่แล้ว
Qlik Sense - Must Know Tips #9 | Pareto Curve (80-20 rule) and more

ความคิดเห็น

  • @janakiramn6818
    @janakiramn6818 19 วันที่ผ่านมา

    Can anyone tell me which object is he using for develop the user input table ? (0:13) Table format

    • @GuilhermeApprobato
      @GuilhermeApprobato 18 วันที่ผ่านมา

      Hi, it is an extension for data entry. Feel free to contact me (I work with it). The name is Inphinity, it is a writeback extension

  • @arunrohilla9597
    @arunrohilla9597 19 วันที่ผ่านมา

    This is amazing! Thank you so much! Please could you tell, what extension and what licenses are required for this writeback functionality? Appreciate your response

    • @GuilhermeApprobato
      @GuilhermeApprobato 19 วันที่ผ่านมา

      @@arunrohilla9597 sure. Connect with me on Linkedin and I send you all the details 🙂 Do you have linkedin?

  • @MrSonninha
    @MrSonninha 28 วันที่ผ่านมา

    Como faço para dividir o DF em Regiões Administrativas?

    • @GuilhermeApprobato
      @GuilhermeApprobato 27 วันที่ผ่านมา

      Imagino que esteja falando do Distrito Federal. Eu não testei mas talvez o caminho seria converter esse SPH em KML e usar no qlik: github.com/artemenseken/shapefiles-Distrito-Federal-DF-

  • @syedmohibhasan6922
    @syedmohibhasan6922 หลายเดือนก่อน

    Its not Power BI, right?

  • @gabrielahormazaballopez6595
    @gabrielahormazaballopez6595 หลายเดือนก่อน

    ... I need to compare sales by province so far this year (this year) and 2 alternatives, 1) with the entire last year or 2) with last year to the current month, that is, to be able to see what sales have been so far by province this year and choose between the two alternatives. I thought of an input variable but I don't know how to solve it I hope you can help me

  • @truphenakariuki3672
    @truphenakariuki3672 หลายเดือนก่อน

    Can this app be intergrated with ESRI products?

  • @dennishumes75
    @dennishumes75 หลายเดือนก่อน

    👋👋👋obrigado por isso….vamos ter mais sobre Qlik Script

  • @eliezergurevich1068
    @eliezergurevich1068 2 หลายเดือนก่อน

    fantastico guilherme! gracias

  • @Turnasollu
    @Turnasollu 2 หลายเดือนก่อน

    Danke für alles you great man

  • @afbdreds
    @afbdreds 2 หลายเดือนก่อน

    You are inspiring

  • @rodrigopennacchi2451
    @rodrigopennacchi2451 2 หลายเดือนก่อน

    Awesome 👏👏

  • @rafiusk22
    @rafiusk22 2 หลายเดือนก่อน

    Excellent. In qlik cloud is it possible to embed only one image to send by e-mail? Or would you only have the options to send PDF and excel?

    • @GuilhermeApprobato
      @GuilhermeApprobato 2 หลายเดือนก่อน

      Hi Rafael, In automation you can use the blocks "Create Report" and "Generate Report" (one after the other) to export sheets to PDF and PPT (I have a video about it here). Excel we can get via the Tabular Reporting. I think there is nothing about images in automation.

    • @rafiusk22
      @rafiusk22 2 หลายเดือนก่อน

      @@GuilhermeApprobato thank you!!

  • @eliezergurevich1068
    @eliezergurevich1068 2 หลายเดือนก่อน

    GENIO!

  • @genkwan1
    @genkwan1 2 หลายเดือนก่อน

    Amazing skill! Thank you!

  • @nbarcelosgyn
    @nbarcelosgyn 2 หลายเดือนก่อน

    Muito bom Approbato, parabéns!

  • @eliezergurevich1068
    @eliezergurevich1068 2 หลายเดือนก่อน

    genio! gracias

  • @jhonnyferrari1049
    @jhonnyferrari1049 2 หลายเดือนก่อน

    Muito obrigado.

  • @rodrigopennacchi2451
    @rodrigopennacchi2451 2 หลายเดือนก่อน

    This have infinite possibilities haha really nice! 👏👏

  • @eliezergurevich1068
    @eliezergurevich1068 2 หลายเดือนก่อน

    fantastico guilherme!

  • @anu5763
    @anu5763 2 หลายเดือนก่อน

    Can you please make a video on best practices/approach for data validation of dashboards. Especially when we have large data sets. It'll be really helpful...

  • @gabrielahormazaballopez6595
    @gabrielahormazaballopez6595 2 หลายเดือนก่อน

    66 / 5.000 When I load the kml file as xml it tells me that the file already exists, 33 / 5.000 The option it gives me is to replace

  • @JoseCarlos-rw1ud
    @JoseCarlos-rw1ud 3 หลายเดือนก่อน

    Thanks, My friend. helped me a lot!

  • @hugoandrade740
    @hugoandrade740 3 หลายเดือนก่อน

    Que bacana. Consegue disponibilizar o arquivo? Essas soluções de writeback são tão complicadas de configurar. É bom ter uma funcional de referência

    • @GuilhermeApprobato
      @GuilhermeApprobato 3 หลายเดือนก่อน

      Oi Hugo! Posso disponibilizar sim. Me manda um alô no linkedin por favor que envio por lá. A configuração da Inphinity é bem fácil, te explico por lá em mais detalhes

  • @Keanegleeson
    @Keanegleeson 3 หลายเดือนก่อน

    This is an amazingly powerful technique. Thanks for sharing, Guilherme! One thing I noticed when implementing this is that the subfield load of the front end input can take a long time if you have a lot of records concatenated in your variable. I instead used an inline load of the variable (using a delimiter of chr(10) instead for my tmp table and got faster loading results. e.g. Button Action --> set variable to concat(<id field>, chr(10)) tmp_table: load * inline [ Id_field $(v_front_end_variable) ];

    • @GuilhermeApprobato
      @GuilhermeApprobato 3 หลายเดือนก่อน

      @@Keanegleeson great to read that 🙂 Thanks for the feedback and nice job on the improvement! I never tested with large datasets but good point

  • @ramandeepsr
    @ramandeepsr 3 หลายเดือนก่อน

    Brilliant 👍

  • @bollavinod4051
    @bollavinod4051 3 หลายเดือนก่อน

    Really helpful for Qlik Developers sir, Please Support us by providing such useful and informative videos

    • @GuilhermeApprobato
      @GuilhermeApprobato 3 หลายเดือนก่อน

      @@bollavinod4051 thank you for the feedback!

  • @Arthur_Assis07
    @Arthur_Assis07 3 หลายเดือนก่อน

    Espetacular! Parabéns!!!

  • @viniciusalves2927
    @viniciusalves2927 3 หลายเดือนก่อน

    Bom dia Guilherme Excelente conteúdo! Não sabia que o Qlik plotava uma área geografica pelo código da cidade, imaginei que fosse necessário ter aquele arquivo kml com as coordenadas. Outro ponto, essa extensão que vai salvando as áreas geograficas dos vendedores é fantástica, pra você ter uma ideia, atualmente trabalho bastante com o mapa do Qlik, entretanto para definir as áreas geograficas, eu fico extraindo para o Excel uma tabela, ajusto na minha base do Excel, coloco o vendedor nessa base e rodo novamente o Qlik. Como o meu aplicativo é leve, roda em 10 segundos e eu tenho uma facilidade com o Excel não onera tanto meu tempo, só que essa extensão resolve o meu "problema". Muito obrigado pelas dicas!

    • @GuilhermeApprobato
      @GuilhermeApprobato 3 หลายเดือนก่อน

      Obrigado pelo feedback Vinicius. Fico feliz que tenha aprendido algo. Sei como é essa dificuldade quando o assunto é área de vendedores bagunçada e coisas do tipo. Se quiser trocar uma ideia sobre isso fico à disposição!

  • @BonJunCuevas
    @BonJunCuevas 3 หลายเดือนก่อน

    Awesome

  • @BonJunCuevas
    @BonJunCuevas 3 หลายเดือนก่อน

    Thanks for sharing. I Always learn new techniques from your channel.

  • @RockyHernandez-oq5su
    @RockyHernandez-oq5su 4 หลายเดือนก่อน

    excelent, long time ago looking for a solution... thanks for share

  • @BonJunCuevas
    @BonJunCuevas 4 หลายเดือนก่อน

    Thank you ❤

  • @PerfectWorldChannel
    @PerfectWorldChannel 4 หลายเดือนก่อน

    Thanks for video , but i think this way will be not good for big data (loding data take more time) ? do you have any idea about this ?

    • @GuilhermeApprobato
      @GuilhermeApprobato 4 หลายเดือนก่อน

      You can do Partial Reload to only load what changed. Have a look at Inphinity and feel free to contact me if you need to know more about it

    • @PerfectWorldChannel
      @PerfectWorldChannel 4 หลายเดือนก่อน

      @@GuilhermeApprobato thanks for reply , but in case that dataload script containt multiple tables,scripts... and for me i need only to load 1 table oin order to do not get impacted by delay

    • @GuilhermeApprobato
      @GuilhermeApprobato 4 หลายเดือนก่อน

      @@PerfectWorldChannel yes, so Partial reload let you keep the tables you had loaded previously untouched, then you just add more data into it. It would only load what changed and add the changed to the tables that were in memory

    • @PerfectWorldChannel
      @PerfectWorldChannel 4 หลายเดือนก่อน

      @@GuilhermeApprobato thanks , i hv follow u in linkedin / Otmane

    • @PerfectWorldChannel
      @PerfectWorldChannel 4 หลายเดือนก่อน

      ​​@@GuilhermeApprobato thanks , i hv add u in link edin pls check "otmane"

  • @DushyantLakhanpal
    @DushyantLakhanpal 4 หลายเดือนก่อน

    Impressive!

  • @joaovitormatos3092
    @joaovitormatos3092 4 หลายเดือนก่อน

    Awesome!

  • @dagosto
    @dagosto 4 หลายเดือนก่อน

    Muito bom, uma aula em um vídeo! Valeu por compartilhar!

  • @MayurSahu-pc3bm
    @MayurSahu-pc3bm 5 หลายเดือนก่อน

    Can you please help me with automation for exporting more than 100,000 cells ?

    • @GuilhermeApprobato
      @GuilhermeApprobato 5 หลายเดือนก่อน

      Hi Mayur, I think the best option would be to use the STORE command via script, but if you can't you can try to use the OneDrive blocks: Create file , Write Line to File , Save File

  • @marksouzacosta
    @marksouzacosta 5 หลายเดือนก่อน

    Esse evento foi demais!

    • @GuilhermeApprobato
      @GuilhermeApprobato 5 หลายเดือนก่อน

      Muito mesmo Mark! E muito legal que nos encontramos lá!

  • @tigerbelly2152
    @tigerbelly2152 5 หลายเดือนก่อน

    Hi Guilherme! Thanks for this excellent tip on variables. I am new to qliksense and this helped me alot. Possible to do a video request for you to teach us the expression syntax in qliksense? I am really confused with all the parentheses and symbols. I am still searching for these stuff online and they are not readily available. If you know a URL link for these guides, it will be great. Appreciate you!

    • @GuilhermeApprobato
      @GuilhermeApprobato 5 หลายเดือนก่อน

      Thank you for the feedback! Yes, this is called Set Analysis. There are some good videos on youtube but I plan to record one too soon. Thanks!

  • @sartiw
    @sartiw 5 หลายเดือนก่อน

    Thank you...

  • @claudiomole3593
    @claudiomole3593 5 หลายเดือนก่อน

    Me pareció un caso práctico muy sencillo de implementar y visualmente muy útil. Gracias por este tip.

    • @GuilhermeApprobato
      @GuilhermeApprobato 5 หลายเดือนก่อน

      Gracias por el comentario Claudio

  • @narband2778
    @narband2778 5 หลายเดือนก่อน

    Great Stuff... Can I know which screen snippet you are using! That's amazing!!

    • @GuilhermeApprobato
      @GuilhermeApprobato 5 หลายเดือนก่อน

      Thanks! It is called ZoomIt , you can draw on the screen, quite good

  • @eliezergurevich1068
    @eliezergurevich1068 5 หลายเดือนก่อน

    gracias

    • @GuilhermeApprobato
      @GuilhermeApprobato 5 หลายเดือนก่อน

      gracias por el comentario Eliezer

  • @Robert8455
    @Robert8455 5 หลายเดือนก่อน

    Thanks Guilherme. You always present great learning nuggets that are easy to follow and understand.

    • @GuilhermeApprobato
      @GuilhermeApprobato 5 หลายเดือนก่อน

      Thanks for the feedback Robert! 😁

  • @emmabellina2625
    @emmabellina2625 6 หลายเดือนก่อน

    Muy bueno, una pregunta podes usar Qlick ilimitado o tambien es por 30 dias y despues caduca, gracias.

  • @antoniolopes8288
    @antoniolopes8288 6 หลายเดือนก่อน

    Nice!

  • @roblange19
    @roblange19 6 หลายเดือนก่อน

    Fantastic … you have me thinking about what is possible for our Safety and ESG solutions !!

    • @GuilhermeApprobato
      @GuilhermeApprobato 6 หลายเดือนก่อน

      Thanks Rob. Yes! I think that is a good use case. Depending on the data we might need to think about running LLM internally so the data doesn't get exposed to 3rd parties.

  • @ViniDenty10
    @ViniDenty10 6 หลายเดือนก่อน

    Your content is very good. Congratulations!

  • @BeatrizApprobato
    @BeatrizApprobato 6 หลายเดือนก่อน

    👏👏👏

  • @nourznidi9054
    @nourznidi9054 6 หลายเดือนก่อน

    Nice, thanks for the videos. They're simple, short, and comprehensible

    • @GuilhermeApprobato
      @GuilhermeApprobato 6 หลายเดือนก่อน

      Thank you for your comment 😀 I'm glad to read that. I should soon update this playlist

    • @nourznidi9054
      @nourznidi9054 6 หลายเดือนก่อน

      @@GuilhermeApprobato Your LinkedIn account, please. I want to follow you