Options settings are used in Vizlib Writeback Tablewhen you have a data type that supports choosing an answer from a selection of possible values.
You'll see Options appear when you select the Dropdown, Icon, Flag, Radiobutton and Multiple Choice data types in the Data panel.
TABLE OF CONTENTS
The Define Options slider lets you choose how you add or edit data. Figures 1 and 2 show a dropdown data type.
Define Options allows you to add, edit or delete functions.
- Type on Label to enter a Label name
- Enter a Value expression by opening the Qlik Sense editor.
- Select the Default value checkbox if required.
- Use the arrow above the Label box to show or hide each option field.
- Click on Add Option to save the field properties and need to add another (see Figure 3).
Figure 1: Define Options
If you select the Use Field setting, you'll use the Options Field to define the data type properties. The Options Qlik Sense expressions, which can be added by clicking the button and opening the Qlik Sense editor to define the field properties. (Figure 2).
Figure 2: Options Field
The dropdown data type lets you build or import a list of values, with the user selecting one. The selected value is then displayed in the table.
- Select Allow Null if you want to include a null option.
- Select the dropdown value type (String or Numeric).
- Use the Default value expression editor to add a default value if you need one.
- Select the Options type you'd like to use.
- Add or edit your dropdown values.
Once you've added your dropdown options, they'll be displayed in the table view, The example we've used in Figure 3 shows a dropdown with 3 values (US, GB and DE).
Figure 3: Dropdown
You can also enable the Custom options sorting setting and choose to sort your dropdown options by Value or Label, and display them in ascending (Asc) or Descending (Desc) order (Figure 4).
Figure 4: Custom Options Sorting
The icon data type is displayed in a dropdown list, with a symbol beside each option. One option can be selected at any time, and null values are allowed.
- Select the Label, Value and Default value.
- Select an icon Color, and then click on the Global Icon button to display the list of shapes. Shapes and colors can be defined for each separate field.
You can see an example in Figure 5, with the Adequate Service list option from the Service Level column displaying a different icon shape.
Figure 5: Icon
To add icon option properties with the Options field (Figure 6), click on the button in Options Field to open the editor.
You can also select a Fallback Icon (a default Icon for any options in the column) by adding an expression using the editor, or clicking on the button under the Fallback Icon field.
Figure 6: Icon Options Field
The flag data type uses a dropdown, and displays a country's flag and the corresponding country code. Null values are allowed.
Figure 7 shows a list of flag values created using the Country dimension from the source data available to the Writeback table. You can see the linked value Country_vzb_options specified in the Options Field, which defines the flag and the name of the country. If Define Options is selected, the list disappears, and an error is returned.
Figure 7: Flag Options Field
If you manually add a country code in the property panel, the error clears and the flag will be displayed again, but as it's no longer linked to Country_vzb_options, it will be the only value in the list (Figure 8).
Figure 8: Flag Define Options
The radiobutton data type lists several options, using a button to display the selected value, which can include null. Figure 89 shows a list of 2 fields (Yes and No) to answer the question Inspection Required?
When Define Options is used, you can add list items by clicking on the Add Option button, and entering an item Value.
Figure 9: Radiobutton Define Options
To add radiobutton data with the Options Field, click on the button to add an expression using the Qlik Sense Editor (Figure 10).
Figure 10: Radiobutton Options Field
The multiple choice data type also presents a list of options, but more than one option can be selected at any one time. Figure 11 shows a list of 3 multiple choice fields, showing the names of the Inspection Team if an inspection is required.
When Define Options is used, you can add multiple choice items by clicking on the Add Option button, and entering an item Value.
Figure 11: Multiple Choice Define Options
To add multiple choice data with the Options Field, click on the button to add an expression using the Qlik Sense Editor (Figure 11).
Figure 12: Multiple Choice Options Field