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
- Working with Columns
- Adding Timestamps Using Columns
- Calculated Column Image Display
- Evaluate Expression as Color
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
|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.|
|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. Supports a maximum of 10 000 rows.|
|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. Supports a maximum of 10 000 rows.|
|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. 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.|
|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. You can display the result as text or as a color.|
|Calculated Column||Use 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.
|Timestamp||Use timestamp if you want to add a system-generated time measurement.|
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
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.
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.
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