Writeback Table Overview
Read-only dashboards are a thing of the past. With Vizlib Writeback Table, you can easily edit, update and comment on data points or entire rows directly in your dashboards while remaining in the analysis flow.
It’s like a version of spreadsheets in Qlik Sense but a lot more powerful, as it lets you:
- Correct your data
- Insert new information
- Adjust numbers
- Create new data segmentations
This topic contains the following sections:
- Getting the most out of Vizlib Collaboration
- Vizlib Collaboration Software Download
- Guides
- Properties
- Best Practice and Troubleshooting
- Changelog
Getting the most out of Vizlib Collaboration
Fully customizable, the Vizlib Writeback Table lets you edit Qlik dimensions, measures, and fields and add new data using many data types. Creating an app using our demo app as a learning tool is also incredibly quick.
Vizlib Writeback Table is part of the Vizlib Collaboration product suite; you can learn more by watching our product and downloading our product catalog. Our Collaboration factsheet summarizes all the available features of Vizlib Collaboration.
The list of supported data output types for the Vizlib Writeback Table is increasing all the time; you can find a summary in the table below.
Our setup guides are designed around connection types, e.g., all of the SQL products listed here will use the SQL setup guide.
Important: Vizlib Writeback Table is only supported in Qlik Sense Cloud for REST destinations.
Supported Data Output Types
Data Integration | Output Type |
---|---|
QVD/CSV/TXT - data written to a flat file. | QVD, CSV (e.g. Excel), TXT files. |
REST - data written to a REST API response. |
All REST-compliant APIs should be supported, including Zapier, Pipedrive, Freshdesk, and Sales. Important: OAuth is not supported for authenticating requests with any Vizlib Writeback operation (this includes Google Sheets). |
Microsoft SQL Server, Microsoft AzureSQL, PostgreSQL, SQLite, MySQL, Oracle Native Coming Soon! - Generic ODBC |
|
Google BigQuery - data written to Google BigQuery. | Google BigQuery |
Snowflake - data written to a Snowflake database | Snowflake |
We've organized our documents into several categories, and to make them easy to find, we've included keywords in the document title.
Vizlib Collaboration Software Download
You can find the latest version of the Vizlib Writeback Table on our User Portal in the Collaboration section of the Downloads page. The demo app is on the Product page for Vizlib Collaboration and can be downloaded from our Demo apps gallery on the Vizlib site.
The software includes an installation file and a demo app showing you how Vizlib Writeback Table works, and you can visit our Demo Apps Gallery, where you can search for examples to get started. You can also review our Architecture Model to see which solution will be best for you.
Guides
Guides are articles that contain technical information relating to Vizlib Writeback Table.
Vizlib products all have the same installation process, and there are installation guides for Qlik Sense server and desktop.
Vizlib Writeback Table shares a Glossary of Terms and Expressionguide with Vizlib Input Form and also has a range of guides for:
- Creating a Table, Setup instructions,
- Integration guides for SQL, Oracle, Snowflake, and Google BigQuery databases, REST APIs, and QVD/CSV/TXT files,
- Adapting your table with Form View.
- Working with Data Types and Columns, Destination Types, and Destination Lock Groups.
- Learning to use features in Analysis Mode, Paste Data Values, managing Column Visibility, and working with Primary Keys using the Update/Delete Options.
There are also guides for Writeback Operations, Qlik Sense Security Rules, and a guide to updating Numeric Formats if you've upgraded to them.
Properties
Properties articles contain information on the Property Panel, which you use in the Qlik Sense Hub to manage functions for Vizlib Writeback Table.
These articles cover subjects like Input Field Options, Associated Fields, Custom Styling, Validation, Bulk Edit, Writeback Settings (Destination Settings , Load Script, Audit Columns, Table Settings, Actions, and Customization.
Best Practice and Troubleshooting
You can use our Best Practice and Troubleshooting articles if you see errors or exceptions in Vizlib Writeback Table. We've compiled documents containing advice on Best Practices, Known Issues, support for dealing with Duplicate Records, and instructions on using Binary Loads.
Changelog
The Changelog contains details for each release of the Vizlib Writeback Table, such as new features and bug fixes. You can find the changelog here, and sign up to receive notifications of new releases for all Vizlib products here.
Related Articles:
- Getting Started with Writeback Table
- Manually Creating a Writeback Table
- Writeback Set Up
- Using Key Columns with Writeback in Vizlib Collaboration
- Destination Types
- Integration Setup - SQL
- Integration Setup - Oracle
- Integration Setup - REST
- Integration Setup - Google BigQuery
- Integration Setup - Snowflake
- VMC Setup - QVD/CSV/TXT
- Data Types and Columns
- Using 'Editable if' in Writeback
- Data Lock (Deprecated)
- Destination Locking, Lock Groups, Queue
- Using Form View with Large Data Sets
- Update/Delete Options
- Glossary of Terms
- Referencing Column/Field values in Expressions
- Numeric Formats (v3.3.0+)
- Analysis Mode
- Column Visibility
- Dynamic Tags
- Pasting Data Values
- Writeback Operations
- Qlik Security Rules for Reloading
- Properties - Input Field Options
- Properties- Associated Fields
- Properties - Custom Styling & Conditional Formatting
- Properties - Validation
- Properties - Bulk Edit
- Vizlib Writeback Table Settings - Data Refresh
- Vizlib Writeback Table Settings - Destination
- Vizlib Writeback Table Settings - Audit Trail, Table Settings, Reload
- Vizlib Writeback Table Settings - Concurrency Handling
- Vizlib Writeback Table Settings - Data Conflicts Resolution
- Vizlib Writeback Table Settings - Actions
- Properties - Appearance
- Properties - Customization
- Best Practice - Binary Loads
- Optimising Reloads Using Binary loads
- Known Issues and FAQ
- Best Practice - Writeback
- Troubleshooting - Duplicate Records (Update)
- Vizlib Writeback Table & Input Form Changelog