Vizlib Home Try Vizlib
Welcome
Login

Vizlib Writeback Table Guides - Data Types and Columns

Vizlib Writeback Table supports a range of data types and utility types you can use when you're adding and formatting columns. 


TABLE OF CONTENTS


Data Types and Utility Types


  • Data types are used to add and edit data fields, helping you to display any data you need to add to the table (e.g. a text section for comments). 
  • Utility types display data that is generated from other values in the table (calculated column) or generated by the data model, (a timestamp).


Table 1: Data Types and Utility 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. You can also enter a URL (for non-editable columns only). Text Area settings can support multiple rows in a single cell, find out more in our article here
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. Supports a maximum of 10 000 rows.
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. Supports a maximum of 10 000 rows. 
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. Supports a maximum of 10 000 rows. 
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
Name
 Description
Calculated ColumnUse Calculated Columns to take data from other columns in the table, make calculations and display the results.
NOTE: Calculated columns should be used with writeback Update operations instead of measures or calculated dimensions, as they are excluded from the matching process which determines which values to update. Measures or calculated dimensions should not be used as they can cause duplication of values held in the data source.
TimestampUse timestamp if you want to add a system-generated time measurement.


Back to Contents


Working with Columns


Column properties in Vizlib Writeback Table are held in the property panel. The easiest way to start editing columns is to click the name in the table when you're in edit mode (Figure 1) which opens the column properties in the property panel.


Figure 1: Column Properties


In version 3.3.0 of Vizlib Writeback Table, we've updated the look and feel of the property panel (Figure 2). If you click on a column, the properties expand from the side and display at the top, making them easier to view and edit. Settings are also grouped, so if you open a section of properties (e.g. custom styling) and click on another column, the same settings will open for that column, making it quicker and easier to navigate and edit settings for multiple columns.


Figure 2: Property Panel v3.3.0


Back to Contents


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.