The Options function is part of the Type panel in Vizlib Writeback Tableand it's used when
You'll see Options appear when you select the
- Radiobutton and
- Multiple Choice
data types in the Data panel.
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. The example in Figure 3 shows a list of
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
The icon data type is also displayed in a dropdown list. One option can be selected at any time, and null values are allowed. The icon gets its name from the symbols it displays next to each list option.
- 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 4, with the GB list option displaying a different icon to the others.
Figure 4: Icon
To add icon option properties with the Options field (Figure 5), click on the button in Options Field and Fallback Icon to add an expression using the Qlik Sense Editor. You can also select an icon by clicking on the button under the Fallback Icon field.
Figure 5: Icon Options Field
The flag data type uses a dropdown to display lists and null values are allowed, but the flag gets its name as the field displays a country's flag and the corresponding country code. Figure 6 shows a list of 3 flag values (US, GB and DE) and a null value created using Define Options.
To add any other values to the list, you can click on the Add Option button and entering a Label value and a Value expression by opening the Qlik Sense editor.
Figure 6: Flag
To add flag properties with the Options Field, click on the button to add an expression using the Qlik Sense Editor (Figure 7).
Figure 7: Flag Options Field
The radiobutton data type consists of a list of more than one option, with only one being selected at any time, but uses a button to display the selection. It can also accept a null value for a field. Figure 8shows a list of 3 fields (US, GB, DE) managed by Define Options, with the US selected.
If you need to add any other values to the list, you can click on the Add Option button, enter a Label value and a Value expression by opening the Qlik Sense editor.
Figure 8: Radiobutton Define Options
To add radiobutton data with Options Field, click on the button to add an expression using the Qlik Sense Editor (Figure 9).
Figure 9: Radiobutton Options Field
The multiple choice data type also presents a list of options, however more than one option can be selected at any one time. Figure 10 shows a list of 3 multiple choice fields (US, GB, DE) managed by Define Options, with the US selected.
Figure 10: Multiple Choice Define Options
To add multiple choice data with Options Field, click on the button to add an expression using the Qlik Sense Editor (Figure 11).
Figure 11: Multiple Choice Options Field
You can find a list of related articles in the Vizlib Writeback Table Overview.