4 ай бұрын
4 ай бұрын
4 ай бұрын
7 ай бұрын
2 жыл бұрын
Пікірлер
@julianhartley521 Күн бұрын
Thanks for this - is it not the case that users that don't own the app can't run a reload via an action?
@diego.freire 6 күн бұрын
não existe mais a conexão com web file
@KIKKI3301 11 күн бұрын
can we make it in qlik sense?
@GuilhermeApprobato 9 күн бұрын
There is an extension (from Qlik, in the dashboard bundle) called Animator. You can create a similar effect, it is super cool. Not so smooth, but great to present.
@it_pro_channel 18 күн бұрын
Super modifications
@sagarupadhyay2915 Ай бұрын
love from India
@derrickthomas5595 Ай бұрын
Hello, does anyone know what to do if the data receives an error while loading and will not load?
@khizer490 Ай бұрын
qlik is not accepting new sbmissions to the garden at this time can anyone help
@janakiramn6818 2 ай бұрын
Can anyone tell me which object is he using for develop the user input table ? (0:13) Table format
@GuilhermeApprobato 2 ай бұрын
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 2 ай бұрын
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 2 ай бұрын
@@arunrohilla9597 sure. Connect with me on Linkedin and I send you all the details 🙂 Do you have linkedin?
@MrSonninha 3 ай бұрын
Como faço para dividir o DF em Regiões Administrativas?
@GuilhermeApprobato 3 ай бұрын
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 3 ай бұрын
Its not Power BI, right?
@gabrielahormazaballopez6595 3 ай бұрын
... 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 3 ай бұрын
Can this app be intergrated with ESRI products?
@AngelineAlvarez-k2c 4 ай бұрын
Lee Steven Smith Thomas Taylor Matthew
@dennishumes75 4 ай бұрын
👋👋👋obrigado por isso….vamos ter mais sobre Qlik Script
@eliezer770 4 ай бұрын
fantastico guilherme! gracias
@Turnasollu 4 ай бұрын
Danke für alles you great man
@afbdreds 4 ай бұрын
You are inspiring
@GuilhermeApprobato 4 ай бұрын
@@afbdreds Thanks Boldré!
@rodrigopennacchi2451 4 ай бұрын
Awesome 👏👏
@GuilhermeApprobato 4 ай бұрын
Thank you Penna!
@rafiusk22 4 ай бұрын
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 4 ай бұрын
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 4 ай бұрын
@@GuilhermeApprobato thank you!!
@eliezer770 4 ай бұрын
GENIO!
@GuilhermeApprobato 4 ай бұрын
Gracias Eliezer!
@genkwan1 4 ай бұрын
Amazing skill! Thank you!
@nbarcelosgyn 4 ай бұрын
Muito bom Approbato, parabéns!
@GuilhermeApprobato 4 ай бұрын
Obrigado Nilton!
@eliezer770 4 ай бұрын
genio! gracias
@jhonnyferrari1049 4 ай бұрын
Muito obrigado.
@rodrigopennacchi2451 4 ай бұрын
This have infinite possibilities haha really nice! 👏👏
@eliezer770 4 ай бұрын
fantastico guilherme!
@GuilhermeApprobato 4 ай бұрын
Obrigado Eliezer!
@anu5763 4 ай бұрын
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 4 ай бұрын
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 5 ай бұрын
Thanks, My friend. helped me a lot!
@GuilhermeApprobato 5 ай бұрын
Thanks for the feedback Jose
@hugocalean 5 ай бұрын
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 5 ай бұрын
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 5 ай бұрын
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 5 ай бұрын
@@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 5 ай бұрын
Brilliant 👍
@GuilhermeApprobato 5 ай бұрын
Thank you!
@bollavinod4051 5 ай бұрын
Really helpful for Qlik Developers sir, Please Support us by providing such useful and informative videos
@GuilhermeApprobato 5 ай бұрын
@@bollavinod4051 thank you for the feedback!
@Arthur_Assis07 6 ай бұрын
Espetacular! Parabéns!!!
@GuilhermeApprobato 6 ай бұрын
Obrigado Arthur!
@viniciusalves2927 6 ай бұрын
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 6 ай бұрын
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 6 ай бұрын
Awesome
@BonJunCuevas 6 ай бұрын
Thanks for sharing. I Always learn new techniques from your channel.
@GuilhermeApprobato 6 ай бұрын
Thank you!
@RockyHernandez-oq5su 6 ай бұрын
excelent, long time ago looking for a solution... thanks for share
@BonJunCuevas 6 ай бұрын
Thank you ❤
@PerfectWorldChannel 6 ай бұрын
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 6 ай бұрын
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 6 ай бұрын
@@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 6 ай бұрын
@@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 6 ай бұрын
@@GuilhermeApprobato thanks , i hv follow u in linkedin / Otmane
@PerfectWorldChannel 6 ай бұрын
@@GuilhermeApprobato thanks , i hv add u in link edin pls check "otmane"
@DushyantLakhanpal 6 ай бұрын
Impressive!
@joaovitormatos3092 7 ай бұрын
Awesome!
@dagosto 7 ай бұрын
Muito bom, uma aula em um vídeo! Valeu por compartilhar!
@GuilhermeApprobato 7 ай бұрын
Obrigado pelo comentário!
@foodielifeofmayur 7 ай бұрын
Can you please help me with automation for exporting more than 100,000 cells ?
@GuilhermeApprobato 7 ай бұрын
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 7 ай бұрын
Esse evento foi demais!
@GuilhermeApprobato 7 ай бұрын
Muito mesmo Mark! E muito legal que nos encontramos lá!
@tigerbelly2152 7 ай бұрын
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 7 ай бұрын
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 7 ай бұрын
Thank you...
@claudiomole3593 7 ай бұрын
Me pareció un caso práctico muy sencillo de implementar y visualmente muy útil. Gracias por este tip.
@GuilhermeApprobato 7 ай бұрын
Gracias por el comentario Claudio
@narband2778 7 ай бұрын
Great Stuff... Can I know which screen snippet you are using! That's amazing!!
@GuilhermeApprobato 7 ай бұрын
Thanks! It is called ZoomIt , you can draw on the screen, quite good