Read-only dashboards are a thing of the past. With the , 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 a little like spreadsheets in Qlik Sense, but a lot more powerful, as it lets you correct your data, insert new information, adjust numbers and create new data segmentations. Fully customizable, Vizlib Writeback Table lets you edit Qlik dimensions and measures and seamlessly add new data using dropdowns, free text fields, radio buttons, date pickers, tags and many more options.
Want to see some examples and use cases? Watch our dedicated webinar for the Vizlib Writeback Table and Vizlib Input Form:
If you want to start working with new data, click on the sheet you'd like to work from in Qlik Sense Hub. When the sheet opens, follow these steps (Figure 2).
- Click on Custom Objects in the far-left panel, to open the custom objects menu.
- Select the VizLib Collaboration option.
- Click and hold the cursor on the Vizlib Writeback Table option.
- Drag and drop the cursor into the central editing panel to create your table view.
- Drag the corner of the table view (highlighted in orange) to increase or decrease the table size.
Figure 2: Create New Writeback Table
Vizlib Writeback Table contains data types and utility types. Data types are used to add new data fields and edit existing data fields to display results clearly and help with data analysis. Utility types hold generated values that can either be applied to display column data (calculated columns) or system generated values, (a row number or a timestamp). A full list of data and utility types can be found in Table 1.
Data type properties in panels. There are slightly different values for each data type.
- Data - Contains the column name, and an expression editor to perform several functions, including adding a placeholder.
- Type - Controls the column data type, including a function for defining display options for dropdown, icon, flag, radiobutton and multiple choice data types.
- Validation - You can select and apply validation conditions for the column in this section.
- Custom Styling - You can set the colors and style used in the column.
- Bulk Edit - Enables editing for all the values held in a column, helping to apply general changes quickly.
- Other Settings - Properties are configured in the expression editor.
Note on Placeholders: A placeholder isn't a data value, but it can be used to highlight a field for the user (Figure 3). In this example Select a Value has been added, and it's displayed until the user makes a selection.
Figure 3: Placeholder
Table 1: Writeback Data Input Types
|Use text for providing commentary on a data point, and help you to provide more context to your data.|
|Dropdown||Dropdowns can be used if you need to prepare several values, but only require one of them to be selected and displayed once it's selected.|
|Checkbox/Toggle||Use a checkbox if you need to return one answer of a binary option (e.g. Enable/Disable).|
|Rating||Ratings are useful for measuring data linked to performance as a value selected from a set of symbols (e.g. 4/5 stars).|
|Icon||Icons are a visual identifier which you can use alongside text to highlight your data.|
|Color||Select a color from the pre-defined palette, or configure your own by using a color code.|
|Date||Display dates in a variety of formats, and set minimum and maximum date checks.|
|Flag||Add extra visuals to country-specific data by displaying the corresponding country flag|
|Chips (Array)||Use chips for displaying and sorting arrays, and they can also support tagging within a dataset.|
|Numeric||Use the numeric data type to collect and display data in a particular numeric format.|
|Slider||Sliders represent a scale between 2 points where the cursor is used to set a value, they're useful for indicating performance metrics.|
|Radio Button||The radio button data type presents lists of options, but unlike a dropdown the entire list is still displayed after one of the options is selected.|
|Multiple Choice||Multiple choice presents a list of options which remain visible once a choice has been made, but allow for more than one selection to be made.|
|Expression||Configure your own data properties with the built-in Qlik Sense Expression Editor.|
|Calculated Column||Use Calculated Columns to take data from other columns in the table, make calculations and display the results|
|Row Number||Row number is used for indexing rows within your table.|
|Timestamp||Use timestamp if you want to add a system generated time measurement.|
You can view the recording of the Vizlib Writeback Table launch webinar here.
You can find out more about Vizlib Writeback Table features in the articles listed below.
- To find out more about using Qlik Sense expressions in Vizlib Writeback Table, please see the article on expressions here.
- Qlik Sense recommend configuring a binary load as part of the their architecture. To read about the benefits of using binary loads in Vizlib Writeback Table please see the article here.
- Locking data in a table holds your changes until you're ready to publish them, to find our more please see the article here.
- Guidelines on pasting data in Vizlib Writeback Table. To find out more please see the article here.
- For instructions on using the Validation functions, please see the article here.
- For instructions on using the Custom Styling panel, please see the article here.
- For instructions on using the Bulk Edit panel, please see the article here.
- For instructions on using the input Options function to add features to the dropdown, icon, flag, radiobutton and multiple choice data types, please see the article here.
- A summary of the security rule configuration for Vizlib Writeback Table can be found here.