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(, chr(10)) tmp_table: load * inline [ Id_field $(v_front_end_variable) ];
Is it possible to add some kind of "multitab function" where it enables users to add info to multiple cells at a time just like they can do in a Excel sheet?
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 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
Hi! The Store command can export the data to some formats, including csv. If you want to download it from the dashboard it is also possible if you right-click on the object and select "download data".
This is very helpful and I've already used this in an app. As a next step, suppose you wanted a field for notes as the last column in your table that would hold a short note explaining the change in the responsible column, the date and by whom. Is there a way to associate the variable input to a specific record or will it apply the note across all records?
Hi Juan, If you are talking about Inphinity Forms, by default it captures who changed the records and when. If you mean that for the qlik work-around, I believe you can associate the variable to specific records if you use the where clauses restricting what you need.
I never thought this could be so simple yet elegant. Thanx Man
I'm glad you liked! Thanks
Fala Guilherme. Saudações dos EUA. Trabalho na IPC Global há 15 anos, empresa parceira da Qlik e também da Inphinity.
Que legal Mark! Acho que já até falei com alguém da IPC ai. Se precisar de algo é só falar 🙂
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(, 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
Is it possible to add some kind of "multitab function" where it enables users to add info to multiple cells at a time just like they can do in a Excel sheet?
Hi Kimball,
Yes, it is possible. It is super customizable 🙂
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?
Nice tip and trick in using qvd and the write back concept
Thanks! :)
Love the content! That’s what I’m looking for.
Thanks for your comment Wendy 🙂
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"
Awesome tip! I will use it for sure!!
HI! I can't understand where to find the excel sheet with the data, where can I download it? thanks for your time!!
Hi! The Store command can export the data to some formats, including csv. If you want to download it from the dashboard it is also possible if you right-click on the object and select "download data".
This is very helpful and I've already used this in an app. As a next step, suppose you wanted a field for notes as the last column in your table that would hold a short note explaining the change in the responsible column, the date and by whom. Is there a way to associate the variable input to a specific record or will it apply the note across all records?
Hi Juan,
If you are talking about Inphinity Forms, by default it captures who changed the records and when. If you mean that for the qlik work-around, I believe you can associate the variable to specific records if you use the where clauses restricting what you need.
Ótimo conteúdo, didático e muito bem estruturado!
Obrigado Luiz!
Very helpful. Thank you a lot!
Thx this gives me so many ideas
Great video and apps
Thank you! :)
Muito bom, uma aula em um vídeo! Valeu por compartilhar!
Obrigado pelo comentário!
Impressive!
Thank you