Create a Writeback solution in Qlik Sense - Easy

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.myinphinity.com/
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

[@DushyantLakhanpal]

Impressive!

[@workwithqlik1642]

I never thought this could be so simple yet elegant. Thanx Man

[@GuilhermeApprobato]

I'm glad you liked! Thanks

[@dagosto]

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

[@GuilhermeApprobato]

Obrigado pelo comentário!

[@cezarioabrantes5476]

Awesome tip! I will use it for sure!!

[@wendywu5359]

Love the content! That’s what I’m looking for.

[@GuilhermeApprobato]

Thanks for your comment Wendy 🙂

[@VinhLe-qy1uy]

Very helpful. Thank you a lot!

[@scotthsieh427]

Thx this gives me so many ideas

[@4ll_That_Jazz]

Ótimo conteúdo, didático e muito bem estruturado!

[@GuilhermeApprobato]

Obrigado Luiz!

[@AyodeleMakun]

Nice tip and trick in using qvd and the write back concept

[@GuilhermeApprobato]

Thanks! :)

[@marksouzacosta]

Fala Guilherme. Saudações dos EUA. Trabalho na IPC Global há 15 anos, empresa parceira da Qlik e também da Inphinity.

[@GuilhermeApprobato]

Que legal Mark! Acho que já até falei com alguém da IPC ai. Se precisar de algo é só falar 🙂

[@PerfectWorldChannel]

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]

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

[@deus5529]

Great video and apps

[@GuilhermeApprobato]

Thank you! :)

[@bhavyamanju3874]

Thank you

[@juanricardo814]

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]

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.

[@kimball4699]

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]

Hi Kimball, Yes, it is possible. It is super customizable 🙂

[@user-tk8vu8hv2q]

HI! I can't understand where to find the excel sheet with the data, where can I download it? thanks for your time!!

[@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".