- 70
- 220 457
Guilherme Approbato
เข้าร่วมเมื่อ 14 มิ.ย. 2014
Here you will find tutorials and tips about the data world and Qlik.
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
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
มุมมอง: 155
วีดีโอ
Learn Qlik Sense - Rename fields Alias and Add Comments
มุมมอง 179หลายเดือนก่อน
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
มุมมอง 1212 หลายเดือนก่อน
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
มุมมอง 2052 หลายเดือนก่อน
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)
มุมมอง 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 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)
มุมมอง 1432 หลายเดือนก่อน
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
มุมมอง 5632 หลายเดือนก่อน
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
มุมมอง 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 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
มุมมอง 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 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)
มุมมอง 2542 หลายเดือนก่อน
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
มุมมอง 2083 หลายเดือนก่อน
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
มุมมอง 1993 หลายเดือนก่อน
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
มุมมอง 1793 หลายเดือนก่อน
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
มุมมอง 2783 หลายเดือนก่อน
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)
มุมมอง 2333 หลายเดือนก่อน
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
มุมมอง 5893 หลายเดือนก่อน
Learn Qlik Sense - The Qlik Associative Engine
Tutorial Qlik - Mapa de Cidades do Brasil com dados IBGE e Writeback Inphinity (cenários)
มุมมอง 2854 หลายเดือนก่อน
Tutorial Qlik - Mapa de Cidades do Brasil com dados IBGE e Writeback Inphinity (cenários)
How SSE works in Qlik - with Tomas Janco (Inphinity)
มุมมอง 3235 หลายเดือนก่อน
How SSE works in Qlik - with Tomas Janco (Inphinity)
Qlik Sense - Must Know Tips #11 | How Dates work + Master Calendar
มุมมอง 9276 หลายเดือนก่อน
Qlik Sense - Must Know Tips #11 | How Dates work Master Calendar
Chat GPT with Qlik Sense and Inphinity - Exploring Unstructured Data
มุมมอง 7566 หลายเดือนก่อน
Chat GPT with Qlik Sense and Inphinity - Exploring Unstructured Data
How to analyze FAO data with Qlik Sense - Animator object
มุมมอง 37710 หลายเดือนก่อน
How to analyze FAO data with Qlik Sense - Animator object
Qlik & Forms - What you need to know to start now
มุมมอง 97011 หลายเดือนก่อน
Qlik & Forms - What you need to know to start now
Easily automate reports in Qlik Saas - Automation
มุมมอง 2.3Kปีที่แล้ว
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
มุมมอง 232ปีที่แล้ว
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
มุมมอง 4.1Kปีที่แล้ว
Qlik Sense - Must Know Tips #10 | Compare column in tables and EXISTS
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
qlik is not accepting new sbmissions to the garden at this time can anyone help
Can anyone tell me which object is he using for develop the user input table ? (0:13) Table format
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
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
@@arunrohilla9597 sure. Connect with me on Linkedin and I send you all the details 🙂 Do you have linkedin?
Como faço para dividir o DF em Regiões Administrativas?
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-
Its not Power BI, right?
... 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
Can this app be intergrated with ESRI products?
Lee Steven Smith Thomas Taylor Matthew
👋👋👋obrigado por isso….vamos ter mais sobre Qlik Script
fantastico guilherme! gracias
Danke für alles you great man
You are inspiring
@@afbdreds Thanks Boldré!
Awesome 👏👏
Thank you Penna!
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?
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.
@@GuilhermeApprobato thank you!!
GENIO!
Gracias Eliezer!
Amazing skill! Thank you!
Muito bom Approbato, parabéns!
Obrigado Nilton!
genio! gracias
Muito obrigado.
This have infinite possibilities haha really nice! 👏👏
fantastico guilherme!
Obrigado Eliezer!
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...
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
Thanks, My friend. helped me a lot!
Thanks for the feedback Jose
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
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
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) ];
@@Keanegleeson great to read that 🙂 Thanks for the feedback and nice job on the improvement! I never tested with large datasets but good point
Brilliant 👍
Thank you!
Really helpful for Qlik Developers sir, Please Support us by providing such useful and informative videos
@@bollavinod4051 thank you for the feedback!
Espetacular! Parabéns!!!
Obrigado Arthur!
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!
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!
Awesome
Thanks for sharing. I Always learn new techniques from your channel.
Thank you!
excelent, long time ago looking for a solution... thanks for share
Thank you ❤
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 ?
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
@@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
@@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
@@GuilhermeApprobato thanks , i hv follow u in linkedin / Otmane
@@GuilhermeApprobato thanks , i hv add u in link edin pls check "otmane"
Impressive!
Awesome!
Muito bom, uma aula em um vídeo! Valeu por compartilhar!
Obrigado pelo comentário!
Can you please help me with automation for exporting more than 100,000 cells ?
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
Esse evento foi demais!
Muito mesmo Mark! E muito legal que nos encontramos lá!
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!
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!
Thank you...
Me pareció un caso práctico muy sencillo de implementar y visualmente muy útil. Gracias por este tip.
Gracias por el comentario Claudio
Great Stuff... Can I know which screen snippet you are using! That's amazing!!
Thanks! It is called ZoomIt , you can draw on the screen, quite good
gracias
gracias por el comentario Eliezer
Thanks Guilherme. You always present great learning nuggets that are easy to follow and understand.
Thanks for the feedback Robert! 😁
Muy bueno, una pregunta podes usar Qlick ilimitado o tambien es por 30 dias y despues caduca, gracias.
Nice!
Fantastic … you have me thinking about what is possible for our Safety and ESG solutions !!
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.
Your content is very good. Congratulations!