Vizlib Home
Welcome
Login

Vizlib Writeback Table - Overview


Read-only dashboards are a thing of the past. With the 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 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:





How to Set Up Vizlib Writeback Table

Setting up Vizlib Writeback Table is a task which only takes a few short steps. Watch our video tutorial here to find out more. 


Editing in Vizlib Writeback Table

If you're working from a table view that's been created and populated with data, open Qlik Sense Hub in your browser, find the sheet you're working with and click the icon to open the sheet (Figure 1). 


  • Click Edit to open the table view for editing. To start working with columns and data types, go to the Data Types section below


Figure 1: Vizlib Writeback Table


Creating a New Writeback Table

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


  1. Click on Custom Objects in the far-left panel, to open the custom objects menu.
  2. Select the VizLib Collaboration option.
  3. Click and hold the cursor on the Vizlib Writeback Table option.
  4. Drag and drop the cursor into the central editing panel to create your table view. 
  5. Drag the corner of the table view (highlighted in orange) to increase or decrease the table size.



Figure 2: Create New Writeback Table


Data Input Types 

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

Data Type 
Name
Description
 
Text/Text Area
Use text for providing commentary on a data point, and help you to provide more context to your data. 
DropdownDropdowns 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/ToggleUse a checkbox if you need to return one answer of a binary option  (e.g. Enable/Disable). 
RatingRatings are useful for measuring data linked to performance as a value selected from a set of symbols (e.g. 4/5 stars). 
IconIcons are a visual identifier which you can use alongside text to highlight your data.
ColorSelect a color from the pre-defined palette, or configure your own by using a color code. 
DateDisplay dates in a variety of formats, and set minimum and maximum date checks.
FlagAdd 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. 
NumericUse the numeric data type to collect and display data in a particular numeric format.
SliderSliders represent a scale between 2 points where the cursor is used to set a value, they're useful for indicating performance metrics.
Radio ButtonThe 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 ChoiceMultiple 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. 
ExpressionConfigure your own data properties with the built-in Qlik Sense Expression Editor.

Utility Type
Calculated ColumnUse Calculated Columns to take data from other columns in the table, make calculations and display the results
Row NumberRow number is used for indexing rows within your table. 
TimestampUse timestamp if you want to add a system generated time measurement. 


Webinar 

You can view the recording of the Vizlib Writeback Table launch webinar here


Related Articles 

You can find out more about Vizlib Writeback Table  features in the articles listed below. 


Expressions - To find out more about using Qlik Sense expressions in Vizlib Writeback Table, please see the article on expressions here.


Binary Loads - 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.


Data Lock Locking data in a table holds your changes until you're ready to publish them, to find our more  please see the article here


Pasting Data Values  - Guidelines on pasting data in Vizlib Writeback Table. To find out more please see the article here


Validation - For instructions on using the Validation functions, please see the article here


Custom Styling - For instructions on using the Custom Styling panel, please see the article here


Bulk Edit - For instructions on using the Bulk Edit panel, please see the article here


Input Options - 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


Security Rule - A summary of the security rule configuration for Vizlib Writeback Table can be found here


K
Kenneth is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.