Conditional functions

The alt function returns the first of the parameters that has a valid number representation. If no such match is found, the last parameter will be returned. Any number of parameters can be used.

alt(expr1[ , expr2 , expr3 , ...] , else)

The class function assigns the first parameter to a class interval. The result is a dual value with a<=x<b as the textual value, where a and b are the upper and lower limits of the bin, and the lower bound as numeric value.

class(expression, interval [ , label [ , offset ]])

The coalesce function returns the first of the parameters that has a valid non-NULL representation. Any number of parameters can be used.

coalesce(expr1[ , expr2 , expr3 , ...])

The if function returns a value depending on whether the condition provided with the function evaluates as True or False.

if(condition , then , else)

The match function compares the first parameter with all the following ones and returns the numeric location of the expressions that match. The comparison is case sensitive.

match( str, expr1 [ , expr2,...exprN ])

The mixmatch function compares the first parameter with all the following ones and returns the numeric location of the expressions that match. The comparison is case insensitive and insensitive to the Japanese Hiragana and Katakana character systems.

mixmatch( str, expr1 [ , expr2,...exprN ])

The pick function returns the n:th expression in the list.

pick(n, expr1[ , expr2,...exprN])

The wildmatch function compares the first parameter with all the following ones and returns the number of the expression that matches. It permits the use of wildcard characters ( * and ?) in the comparison strings. * matches any sequence of characters. ? matches any single character. The comparison is case insensitive and insensitive to the Japanese Hiragana and Katakana character systems.

wildmatch( str, expr1 [ , expr2,...exprN ])