Qlik Write Table FAQ

[Emile_Koslowski]

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

Content

• Data and metadata
• Q: What happens to changes after 90 days?
• Q: Which data is stored in the change-store?
• Q: Is there an audit trail or a history?
• Pricing and packaging
• Q: Where can I find pricing information?
• Q: Is this available to all cloud editions of Qlik?
• Access and Permissions
• Q: Does the Can Edit space role automatically grant access to the Write Table?
• Q: Does the write table support section access?
• Q: Which permissions are required to read from the change-stores API?
• Q: Which permissions are required to use the Write Table chart?
• UI and Input Types
• Q: What input fields are available?
• Q: Can we use dynamic values for the dropdown input field?
• Q: Is the write table available on pivot tables?
• Deployment
• Q: Will the write table come to government editions of Qlik?
• Q: Will the write table come to on-prem versions of Qlik?

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. Information about setting up the Analytics REST connector is available in Extracting write table changes with the REST connector in Qlik Cloud. A how-to article will be released soon.
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.

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: 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.