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.

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.

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