Selection Actions

Vizlib Selection Actions are made up of four (4) functionalities that assist your users in a variety of ways within Qlik. From quickly selecting alternate values or selecting all possible values.

Note: Within these examples, you can use variables to make the fields dynamic.

This topic contains the following sections:

• Select Alternative

• Select Excluded

• Select Possible

• Selection in Field

Select Alternative

Select Alternative(Figure 1.2) selects all possible values of the field that are not currently being selected.

• Field

  • The field you want to clear must be written between an equals sign and two (2) apostrophes, like so ='Field'.

  • Do not include Square Brackets within the field [ [ ] ].

Figure 1.1: Vizlib Action | Select Alternative

Figure 1.2: Vizlib Action | Select Alternative

As seen in Figure 1.3, the Vizlib Filter allows you to Select alternatives within its context menu.

Figure 1.3: Vizlib Action | Select Alternative with the Vizlib Filter

Select Excluded

Select Excluded (Figure 2.2) Selects the unselectable values within a field. This is represented as a Dark Gray value within the filters or Qlik's Selection Menu.

• Field

  • The field you want to clear must be written between an equals sign and two (2) apostrophes, like so ='Field'.

  • Do not include Square Brackets within the field [ [ ] ].

Figure 2.1: Vizlib Action | Select Excluded

Figure 2.2: Vizlib Action | Select Excluded

As seen in Figure 2.3, the Vizlib Filter allows you to Select excluded within its context menu.

Figure 2.3: Vizlib Action | Select Excluded with the Vizlib Filter

Select Possible

Select Possible (Figure 3.2) is a quick way to select all available options within the chosen field. This action best works if you select or filter down the values within the field. Use this action to select all the possible values then.

Note:

This action only works for the first initial use, meaning if you make a selection within that specific field, or you activate the action with, i.e. a Vizlib Button, then you cannot use this action to add more values when they become available. You must clear that field to be able to use it again.

View Figure 3.2 to see an example using the Vizlib Filter.

• Field

  • The field you want to lock must be written between an equals sign and two (2) apostrophes, like so ='Field'.

  • Do not include Square Brackets within the field [ [ ] ].

Figure 3.1: Vizlib Action | Select Possible

Figure 3.2: Vizlib Action | Select Possible

As seen in Figure 3.3, the Vizlib Filter allows you to Select possible within its context menu.

Figure 3.3: Vizlib Action | Select Possible with the Vizlib Filter

Selection in Field

Selection in Field (Figure 4.5) makes a selection within the defined field. Either set up a basic value, i.e. when clicked, select 'A', or define an expression you can act upon when a criterion is met.

Many possibilities are available; below are examples.

• Field Value

  • Define the value you want to select with just the value, like one of the examples below.

    • A

    • United Kingdom

      

      Figure 4.1: Vizlib Action | Select in Field with one value

  • If you want to make many selections within the field, then use parentheses [ ( ) ] and separate each value with a pipe [ | ]. See the example below.

    • (A|B|C)

      

      Figure 4.2: Vizlib Action | Select in Field with many selections

  • If the value contains a space within it, like, i.e. the United Kingdom, then you wrap that value in quote marks [ " " ]. See the example below.

    • ("United Kingdom"|Brazil|"South Korea")

      

      Figure 4.3: Vizlib Action | Select in Field with many selections and spaces

  • To use an expression within the Field Value, then format it like the examples below.

    • ='(' & if(Dim1 = 'A', '(3|6|9)') & ')'

    • ='(' & Concat(distinct {<Continent={‘Europe’}>} [City], '|') & ')'

      

      Figure 4.4: Vizlib Action | Select in Field with an expression

Figure 4.5: Vizlib Action | Select in Field