Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
SarveshKumar
Contributor II
Contributor II

Best Practice for using source filed vs Writeback fields in Qlik Sense Workflow Application

Hi Team,

I am working on a Qlik Sense workflow application where data is loaded from a single source file and split into multiple logical tables associated through: Key Delivery.

I am using Straight tables for source/master data display 
writeback tables for user updates
At the same time, users are expected to manually update operational fields through writeback tables.

My Question:

 can editable/writeback columns be reliably used as filter pane fields in Qlik Sense? 
or is it recommended that filters should only come from stable source/master data tables, while writeback tables should only store operational/manual update fields?

I would like to understand:

Best Practice
performance impact
data consistency
recommended enterprise design approach
Thanks

 

Labels (1)
2 Solutions

Accepted Solutions
marksouzacosta
MVP
MVP

Hi @SarveshKumar,

There is no restriction on using Writeback fields as filters in your applications, but you have to load the recorded values into your application - like a regular field.

So, your application will end with the writeback fields and writeback fields loaded into your application through the Load Script - as a regular field.

I made a video showing how you can load writeback data into your app:
https://youtu.be/B50XAm3yJMg?si=B-eEfoyLdBxtzJ4X

 

Regards,

Mark Costa

Read more at Data Voyagers - datavoyagers.net
Follow me on my LinkedIn | Know IPC Global at ipc-global.com

View solution in original post

marksouzacosta
MVP
MVP

Those are the details about the permissions needed:
Reference: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Visualizations/WriteTabl...

marksouzacosta_0-1778778922485.png

 

Regards,

Mark Costa

 

Read more at Data Voyagers - datavoyagers.net
Follow me on my LinkedIn | Know IPC Global at ipc-global.com

View solution in original post

5 Replies
marksouzacosta
MVP
MVP

Hi @SarveshKumar,

There is no restriction on using Writeback fields as filters in your applications, but you have to load the recorded values into your application - like a regular field.

So, your application will end with the writeback fields and writeback fields loaded into your application through the Load Script - as a regular field.

I made a video showing how you can load writeback data into your app:
https://youtu.be/B50XAm3yJMg?si=B-eEfoyLdBxtzJ4X

 

Regards,

Mark Costa

Read more at Data Voyagers - datavoyagers.net
Follow me on my LinkedIn | Know IPC Global at ipc-global.com

SarveshKumar
Contributor II
Contributor II
Author

Thank you @marksouzacosta .

SarveshKumar
Contributor II
Contributor II
Author

Hi @marksouzacosta ,

Just want to know what level of access do I need for the implementation of the writeback and establishing a connection and reloading them back to Qlik Sense.

 

Regards 

Sarvesh

marksouzacosta
MVP
MVP

Those are the details about the permissions needed:
Reference: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Visualizations/WriteTabl...

marksouzacosta_0-1778778922485.png

 

Regards,

Mark Costa

 

Read more at Data Voyagers - datavoyagers.net
Follow me on my LinkedIn | Know IPC Global at ipc-global.com

SarveshKumar
Contributor II
Contributor II
Author

@marksouzacosta ,
thank you for the help.

 

Regards

Sarvesh