Тёмный

Create a Writeback solution in Qlik Sense - Easy 

Guilherme Approbato
Подписаться 2,1 тыс.
Просмотров 6 тыс.
50% 1

Learn how to use variables and qlik objects to create your own writeback solution in your app.
In this tutorial we will see how to create a writeback step-by-step.
Below I posted the steps if you wish to paste in your app.
I also showed how a professional writeback extension works, and if you want to know more about it you can message me on linkedin.
Links:
My linkedin: / guilhermeapprobato
Qlik Tips Playlist: • Qlik Sense Tips - Must...
Inphinity Extensions: www.myinphinit...
Steps:
// Load data and store in qvd (faster) as "original" and "consumption"
// Create 2 variables - 1 to input new values and 1 to list dimensions that will be changed
// Create a TEMP table using subfield with the variables
// Load qvd using WHERE EXISTS, changing the records
// Store new qvd with changes
// Empty variables and drop table

Опубликовано:

 

6 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 34   
@workwithqlik1642
@workwithqlik1642 Год назад
I never thought this could be so simple yet elegant. Thanx Man
@GuilhermeApprobato
@GuilhermeApprobato Год назад
I'm glad you liked! Thanks
@Keanegleeson
@Keanegleeson 2 месяца назад
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) ];
@GuilhermeApprobato
@GuilhermeApprobato 2 месяца назад
@@Keanegleeson great to read that 🙂 Thanks for the feedback and nice job on the improvement! I never tested with large datasets but good point
@4ll_That_Jazz
@4ll_That_Jazz Год назад
Ótimo conteúdo, didático e muito bem estruturado!
@GuilhermeApprobato
@GuilhermeApprobato Год назад
Obrigado Luiz!
@marksouzacosta
@marksouzacosta Год назад
Fala Guilherme. Saudações dos EUA. Trabalho na IPC Global há 15 anos, empresa parceira da Qlik e também da Inphinity.
@GuilhermeApprobato
@GuilhermeApprobato Год назад
Que legal Mark! Acho que já até falei com alguém da IPC ai. Se precisar de algo é só falar 🙂
@wendywu5359
@wendywu5359 Год назад
Love the content! That’s what I’m looking for.
@GuilhermeApprobato
@GuilhermeApprobato Год назад
Thanks for your comment Wendy 🙂
@scotthsieh427
@scotthsieh427 8 месяцев назад
Thx this gives me so many ideas
@cezarioabrantes5476
@cezarioabrantes5476 10 месяцев назад
Awesome tip! I will use it for sure!!
@AyodeleMakun
@AyodeleMakun Год назад
Nice tip and trick in using qvd and the write back concept
@GuilhermeApprobato
@GuilhermeApprobato Год назад
Thanks! :)
@dagosto
@dagosto 3 месяца назад
Muito bom, uma aula em um vídeo! Valeu por compartilhar!
@GuilhermeApprobato
@GuilhermeApprobato 3 месяца назад
Obrigado pelo comentário!
@VinhLe-qy1uy
@VinhLe-qy1uy 9 месяцев назад
Very helpful. Thank you a lot!
@juanricardo814
@juanricardo814 8 месяцев назад
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?
@GuilhermeApprobato
@GuilhermeApprobato 8 месяцев назад
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.
@DushyantLakhanpal
@DushyantLakhanpal 3 месяца назад
Impressive!
@deus5529
@deus5529 Год назад
Great video and apps
@GuilhermeApprobato
@GuilhermeApprobato Год назад
Thank you! :)
@bhavyamanju3874
@bhavyamanju3874 Год назад
Thank you
@PerfectWorldChannel
@PerfectWorldChannel 3 месяца назад
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 3 месяца назад
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 3 месяца назад
@@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 3 месяца назад
@@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 3 месяца назад
@@GuilhermeApprobato thanks , i hv follow u in linkedin / Otmane
@PerfectWorldChannel
@PerfectWorldChannel 3 месяца назад
​​@@GuilhermeApprobato thanks , i hv add u in link edin pls check "otmane"
@kimball4699
@kimball4699 11 месяцев назад
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?
@GuilhermeApprobato
@GuilhermeApprobato 11 месяцев назад
Hi Kimball, Yes, it is possible. It is super customizable 🙂
@CarolaCaterino
@CarolaCaterino Год назад
HI! I can't understand where to find the excel sheet with the data, where can I download it? thanks for your time!!
@GuilhermeApprobato
@GuilhermeApprobato Год назад
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".
Далее
Ad-Hoc Reporting in Qlik Sense
5:04
Просмотров 9 тыс.