article Qlik Write Table FAQ in Official Support Articles

Qlik Write Table FAQ

Emile_Koslowski — Mon, 13 Apr 2026 11:39:50 GMT

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:

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 Automate for details.
Or use Qlik Automate to sync changes to Excel files, see How to extract changes from the change store (Write Table) and store them in an Excel file using Qlik Automate for details.
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
Use the change-stores API directly in a tool of your choosing. The api specs are available here: https://qlik.dev/apis/rest/analytics/change-stores/

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.

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.

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, the write table is available in the government editions of Qlik.

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.

Re: Qlik Write Table FAQ

Gui_Approbato — Thu, 11 Dec 2025 02:54:01 GMT

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

Re: Qlik Write Table FAQ

marksouzacosta — Thu, 11 Dec 2025 06:20:31 GMT

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/WriteTable/Create/create.htm#WorkflowFinal:~:text=changes%20with%20the-,REST%C2%A0,-connector%20in%20Qlik

The correct value is:

links/next/href

Regards,

Mark Costa

Re: Qlik Write Table FAQ

marksouzacosta — Thu, 11 Dec 2025 07:26:44 GMT

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

Re: Qlik Write Table FAQ

Sonja_Bauernfeind — Thu, 11 Dec 2025 09:46:17 GMT

Hello @marksouzacosta

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

All the best,
Sonja

Re: Qlik Write Table FAQ

Emile_Koslowski — Thu, 11 Dec 2025 11:07:47 GMT

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

Re: Qlik Write Table FAQ

BuildItStrong — Fri, 12 Dec 2025 22:05:42 GMT

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.

Re: Qlik Write Table FAQ

Bel01234 — Mon, 15 Dec 2025 12:42:26 GMT

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!

Re: Qlik Write Table FAQ

marksouzacosta — Mon, 15 Dec 2025 14:39:02 GMT

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

Re: Qlik Write Table FAQ

tres_sdz — Wed, 17 Dec 2025 08:06:23 GMT

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' !

Re: Qlik Write Table FAQ

oli_hardy — Fri, 19 Dec 2025 15:54:47 GMT

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

Re: Qlik Write Table FAQ

Bel01234 — Tue, 23 Dec 2025 12:31:21 GMT

Hi @marksouzacosta. Thanks for your Snowflake video, but it’s quite different from Databricks. In the automation, I don’t have blocks to run a query or insert changes into Databricks. I suppose I could replace the Do Query block with Start Pipeline Update and run a delete query, but I’m not sure how to apply the changes to Databricks without the Insert Bulk block. I don’t see any similar block available.

Re: Qlik Write Table FAQ

marksouzacosta — Fri, 26 Dec 2025 05:42:00 GMT

Hi @Bel01234,

I'm not experienced with Databricks and Qlik Automation Databricks blocks but I was able to achieve the same thing using the Call URL basic block to call Databricks endpoints to send SQL Statements - I'm sure there must be better ways to do that.

This is what I have done:

The Params in this Block works as Body parameters when you set the Method as POST.
You must have in hands your wharehouse id, catalog and schema. This is my statement to delete all records from the FILM_WB table:

TRUNCATE TABLE FILM_WB

This is the full JSON Body:

{ "statement": "TRUNCATE TABLE FILM_WB", "warehouse_id": "your_warehouse_id_here", "catalog": "playground", "schema": "default" }

Use the header to do a Bearer Authentication:

The second Call URL block is similar to the first one. The only change is the Statement. The block is inside the List Current Changes From Change Store block loop, so it will be executed for every record loaded there. The Statement parameter looks like this:

Regards,

Mark Costa

Re: Qlik Write Table FAQ

Bel01234 — Fri, 02 Jan 2026 13:36:09 GMT

Thank you very much @marksouzacosta . Your answer was very helpful, and I’ve got it working now.

Re: Qlik Write Table FAQ

Anders77 — Thu, 08 Jan 2026 12:58:20 GMT

Excellent feature!

But I'm having trouble getting it to work for the end users!
The User Default security rule has the "Manage write table charts"=Allowed and the user has "Can contribute" on the space. They have Professinal entitlements!
Can get it to work with the "Can manage" permission on the space but would like to just use "Can contribute".
Documentation says......

In managed spaces, one of the following:
- Owner (of space)
- Can manage
- Can contribute

Any ideas what I'm missing?

Re: Qlik Write Table FAQ

Emile_Koslowski — Mon, 12 Jan 2026 13:21:27 GMT

@Anders77 , this seems to be a bug and we have started an investigation. Thank you for sharing this.

Re: Qlik Write Table FAQ

Anders77 — Mon, 12 Jan 2026 14:51:53 GMT

@Emile_Koslowski
Great. Thanks for info!

Re: Qlik Write Table FAQ

martingries — Mon, 12 Jan 2026 16:30:17 GMT

Hi @Emile_Koslowski,

we found out, that it's not possible to send the data to Excel for the write-back table?
BR
Martin

Re: Qlik Write Table FAQ

matthias_v — Thu, 29 Jan 2026 16:00:44 GMT

Hello,

Could the api/analytics/change-stores endpoints be added to qlik.dev please?

I cant seem to find them, unless I missed them somehow, perhaps because of the ongoing (namespace)refactor.

Kr,

Matthias

Re: Qlik Write Table FAQ

Emile_Koslowski — Fri, 30 Jan 2026 12:56:33 GMT

@martingries we just finished this how to guide on syncing write table/change store data to Excel files through Qlik Automate: https://community.qlik.com/t5/Official-Support-Articles/How-to-extract-changes-from-the-change-store-Write-Table-and/ta-p/2541457