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

Announcements
ALERT: The support homepage carousel is not displaying. We are working toward a resolution.

Qlik Write Table FAQ

100% helpful (1/1)
cancel
Showing results for 
Search instead for 
Did you mean: 
Emile_Koslowski
Employee
Employee

Qlik Write Table FAQ

Last Update:

Dec 24, 2025 4:52:48 AM

Updated By:

Emile_Koslowski

Created date:

Dec 10, 2025 9:31:59 AM

This document contains frequently asked questions for the Qlik Write Table.

Content

 

Data and metadata

Q: What happens to changes after 90 days?

A: After 90 days, changes will be permanently deleted from the change store and will no longer be available in the Write Table chart.

There are three options to set up a scheduled extraction of these changes:

  1. Use Qlik Automate to set up a scheduled sync of these changes to a database of your choice; see How to extract changes from the Change Store (Write Table) and store them in a database using Qlik A... for details.
  2. Use Qlik Load Scripts to create a scheduled sync to load these changes into a QVD or the app's data model. See How to extract changes from the change store (Write table) and store them in a QVD   
  3. Use the change-stores API directly in a tool of your choosing. The api specs will be released soon.

 

Q: Which data is stored in the change-store?

A: Every new change is appended to the change store, together with a primary key and the metadata to track which user made the change and when they made it.

 

Q: Is there an audit trail or a history?

A: When new changes are made, they are appended to the change store with a 90-day TTL (time to live). The write table displays the latest change in the chart, and you can hover a cell in the chart to see previous change values with the user's info and timestamp.

The full history of all changes can be retrieved through the List Change Store History block in Qlik Automate or through the /changes endpoint in the API (until their 90-day TTL expires).

 

Pricing and packaging

Q: Where can I find pricing information?

A: The write table is provided as an included capability.

Q: Is this available to all cloud editions of Qlik?

A: No, the Write Table is only available in the following editions of Qlik Cloud:

  • Qlik Cloud Analytics Premium
  • Qlik Cloud Analytics Enterprise
  • Qlik Sense Enterprise SaaS

 

Access and Permissions

Q: Does the Can Edit space role automatically grant access to the Write Table?

A: No. Adding and configuring the Write Table in a sheet requires the Manage write table charts user permission. This permission is automatically enabled in the User default role. Tenant admins can manage the Default user role or create a custom role that includes this permission.

set user default.png

 

Q: Does the write table support section access?

A: Section access is applied only to data that is in use by the Qlik engine.

The records shown in a write table depend on the primary key, which is configured using engine data. Therefore, if the write table is used in an app that uses section access, the records shown in the table will be restricted by section access.

However, the write table interaction data, such as edits created during analysis sessions, are stored in a change store. This happens separately from the engine, meaning Section access is not applied on a change store or on the change-stores API.

Therefore, users with permission to read from the change-stores API will be able to read all data from a change store regardless of the Section access rules.

For additional details, see Section access limitations.

 

Q: Which permissions are required to read from the change-stores API?

A: Users with the full Manage write table charts permission can access the change-stores API and use it to read changes from change-stores they have access to. It is also possible to create an OAuth credential that has limited API access to the change-stores API. Assigning this limited access to a user is not yet possible.

 

Q: Which permissions are required to use the Write Table chart?

A: Users with the full Manage write table charts permission or the Read and write access only permission can use the Write Table chart to read and write changes through the chart.

See Write table permissions for details.

UI and Input Types

Q: A Write Table chart suddenly became read-only (but loads successfully)

A: Please make sure that Touch screen mode is disabled for your app. The write table is read-only when touch screen mode is enabled.

Emile_Koslowski_1-1766162645499.png

 

Q: What input fields are available?

A: Text input box (manual user input) and dropdown (single select).

Q: Can we use dynamic values for the dropdown input field?

A: Not as of yet. For now, the values are a hardcoded list configurable in an editable column’s settings.

Q: Is the write table available on pivot tables?

A: No, this is not supported and not on the roadmap.

 

Deployment

Q: Will the write table come to government editions of Qlik?

A: Yes, we are planning to make the write table available in the government editions of Qlik soon.

Q: Will the write table come to on-prem versions of Qlik?

A: No, the write table is only available on Qlik Cloud. There are no plans to make it available in on-prem versions.

Labels (2)
Comments
Gui_Approbato
Partner - Creator III
Partner - Creator III

Great FAQ and great release @Emile_Koslowski !

I made a video to guide new users on how to use the Write table and load data back into Qlik. Sharing it here:

https://www.youtube.com/watch?v=mZk_2v2m4U8 

 

marksouzacosta

Hi @Emile_Koslowski,

I found an issue in the documentation page:
https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Visualizations/WriteTabl...

marksouzacosta_0-1765433976946.png

 

The correct value is:

links/next/href

 

Regards,

Mark Costa

marksouzacosta

I have published a video showing how to store the Qlik Write back changes in Snowflake and QVD.

YouTube video:
https://youtu.be/B50XAm3yJMg

Data Voyagers post:
https://www.datavoyagers.net/post/native-qlik-write-back-is-here-store-to-snowflake-qvd 

 

Regards,
Mark Costa

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @marksouzacosta 

Thanks! I'm looking into the help site problem you reported.

All the best,
Sonja

Emile_Koslowski
Employee
Employee

Thanks @marksouzacosta! You are absolutely correct, an update is on it's way.

BuildItStrong
Contributor III
Contributor III

I am looking forward to exploring the this new table.  The video by Gui_Approbato filled in some gaps in my knowledge and gave me all the info that I needed to pull Write Table data into the data load editor.

Bel01234
Partner - Contributor II
Partner - Contributor II

Hi, is it possible to save changes directly to Databricks instead of a QVD or Excel file? If so, is there a video that shows how to save to Databricks? Thanks!

marksouzacosta

Hi @Bel01234 I made a video showing how to save on Snowflake. To convert to Databricks, should be easy. Please let me know if you have any questions:

https://youtu.be/B50XAm3yJMg

 

Regards,

Mark Costa

tres_sdz
Contributor II
Contributor II

It seems 'real-time' sync - means same input view with active session. This write-table is great!
We are greedy and want more 🙂 
One more step forward could be referencing the input data in expression and refresh without having to reload the app - would be a 'real game-changer' !

oli_hardy
Partner - Contributor II
Partner - Contributor II

My mistery with the "locked" input table on some environments has been solved, thanks to a linkedin post from eric mertens mentioning that the table becomes read-only if touch-screen mode is on


Version history
Last update:
2 weeks ago
Updated by: