Switch Function

image_pdfimage_print

This function allows the definition of a complex condition to determine the function value. It should avoid the usage of script-based functions such as Groovy or JavaScript, which contain mainly IF and CASE statements.

The condition is applied to one particular column (i.e. input field) of the data source.

Several switch conditions can be defined as follows:

Deny

unchecked: all nodes that fulfill the filter criteria are included in the selection.

checked: all nodes that fulfill the filter criteria are excluded from the selection.

Operator

equal: only the specified elements are filtered. Example: Austria

inAlphaRange: alphanumerical values in a particular range are filtered. Examples include:

  • inclusive Range [A100,A200]”
  • exclusive Range: “(A100,A200)”
  • half-open interval: “[A100,)”
  • half-open interval: “(,A100)”

isEmpty: empty values (blank, space, or multiple space values).

like: filters the dimension elements according to regular expressions.

inRange: Numerical values in a particular range are filtered. Can also be used as a means of equality check for numerical values with the same upper and lower limit, such as [0,0] to check for the numerical value 0. Examples:

  • inclusive Range: “[100,200]”
  • exclusive Range: “(100,200)”
  • half-open interval: “[100,)”
  • half-open interval: “(,100)”

 

Value

 

Result

The resulting value if the condition applies. It can be defined either as a constant or dynamically as a reference to a further source column.

image_pdfimage_print