Vizlib Home
Welcome
Login

Vizlib Writeback Table - Input Field Options

Input Field Options

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 

  • Dropdown, 
  • Icon, 
  • Flag, 
  • Radiobutton and 
  • Multiple Choice 

data types in the Data panel.


Define Options

The Define Options slider lets you choose how you add or edit data. Figures 1 and 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


Options Field

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 


Dropdown

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 


Icon

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


Flag

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


Radiobutton

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


Multiple Choice

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


Further Reading

You can find a list of related articles in the Vizlib Writeback Table Overview

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.