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.
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). |
| SQL, Oracle - data written to an SQL database. | Microsoft SQL Server, Microsoft AzureSQL, PostgreSQL, SQLite, MySQL, Oracle Native |
| 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
- Vizlib Writeback Table Guides - Integration Setup - SQL
- Vizlib Writeback Table Guides - Integration Setup - Oracle
- Vizlib Writeback Table Guides - Integration Setup - REST
- Vizlib Writeback Table Guides - Integration Setup - Google BigQuery
- Vizlib Writeback Table Guides - Integration Setup - Snowflake
- Vizlib Writeback Table Guides - VMC Setup - QVD/CSV/TXT
- Vizlib Writeback Table Guides - Data Types and Columns
- Vizlib Writeback Table Guides - Using 'Editable if' in Writeback
- Vizlib Writeback Table Guides - Data Lock (Deprecated)
- Vizlib Writeback Table Guides - Destination Locking, Lock Groups, Queue
- Vizlib Writeback Table Guides - Using Form View with Large Data Sets
- Vizlib Writeback Table and Input Form Guides - Update/Delete Options
- Vizlib Writeback Table and Input Form - Glossary of Terms
- Vizlib Writeback Table and Input Form Guides - Referencing Column/Field values in Expressions
- Vizlib Writeback Table and Input Form Guides - Numeric Formats (v3.3.0+)
- Vizlib Writeback Table Guides - Analysis Mode
- Vizlib Writeback Table Guides - Column Visibility
- Vizlib Writeback Table Guides - Dynamic Tags
- Vizlib Writeback Table Guides - Pasting Data Values
- Vizlib Writeback Table Guides - Writeback Operations
- Vizlib Writeback Table Guides - Qlik Security Rules for Reloading
- Vizlib Writeback Table Properties - Input Field Options
- Vizlib Writeback Table and Input form Properties - Associated Fields
- Vizlib Writeback Table Properties - Custom Styling & Conditional Formatting
- Vizlib Writeback Table Properties - Validation
- Vizlib Writeback Table 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
- Vizlib Writeback Table Properties - Customization
- Vizlib Writeback Table Best Practice - Binary Loads
- Optimising Reloads Using Binary loads
- Known Issues and FAQ
- Vizlib Writeback Table Best Practice
- Vizlib Writeback Table Troubleshooting - Duplicate Records (Update)
- Vizlib Writeback Table and Input Form Changelog