Vizlib Home Try Vizlib

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. 


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 
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. You can display the result as text or as a color. 
Utility Type
Calculated ColumnUse Calculated Columns to take data from other columns in the table, make calculations and display the results (either as text or as an image).
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

Adding Timestamps Using Columns

While you can currently add a timestamp as a utility type, the function to add a timestamp for input in Vizlib Writeback Table is not yet available. There are two methods we recommend for inputting a timestamp using columns. 

  • Use two drop-downs - Add a dropdown data type to input hours, and another one for inputting minutes. You can combine them when you are reading the data back if you need to.
  • Use a Text data type field and add validation with the Regex (regular expression) option (Figure 3).

Figure 3: Regex 

We've listed an example Regex for a timestamp here. 

= '(0[0-9]|1[0-9]|2[0-3]):[0-5][0-9]'

Back to Contents

Calculated Column Image Display

With v3.8.0 of Vizlib Writeback Table, you can use an image to display results in a calculated column utility type. In the Type section of the column settings, you can select the Display Mode as image or text. Once you've set the display mode to Image, you can enter an expression in the editor containing the image url (remember to wrap the URL in single quotes or it won't be validated). If you need to edit the image size within the cell, you can use the Adjust Image Height settings in Custom Styling. Figure 4 shows an example of an image being added and adjusted. 

Figure 4: Display as Image

This setting could be used with complex expressions, where a specific image is displayed when a condition is met. 

Back to Contents

Evaluate Expression as Color

With v3.8.0 of Vizlib Writeback Table, you can evaluate the Expression data type as either text or a color. In the Type settings for the column, you can set Show evaluated value as to Color, then display a color when the evaluation uses a hex color code. Figure 5 shows the evaluation display changing color when a color code is entered. 

Figure 5: Expression as Color

Back to Contents

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