Supported Functions and Operators in Visualizer Expressions

All functions and operators are supported in Advanced mode, with the exception of TRANSFORM.

A subset of BQL functions and operators are supported in the Visualizer Expression Builder Basic Mode, as listed below.

See Adding an Expression in Visualizer and Logical Query Language Functions.

Variable Syntax

When referencing a variable in BQL, for example in a report expression or an ETL script, use the GETVARIABLE function:

GETVARIABLE('variable_name')

Do not use the V{} syntax. See Using Variables.

Supported in Expression Builder Basic Mode

Logical

IIF

IFNULL

ISNAN

Math

ABS

CEILING

FLOOR

SQRT

EXP

POW

RSUM

MEDIAN

Dates

DATEADD

DATEDIFF

DATETIME

NOW 

NOWDATE

Strings

FORMAT

TOLOWER

TOUPPER

SUBSTRING

LENGTH

TRIM

Lookups

STAT

Rank

RANK

Prompts and Variables

GETVARIABLE

GETPROMPTVALUE

Operators

+

-

*

/

=

<

>

<>

<=

>=

AND

IS NULL

IS NOT NULL

LIKE

NOT LIKE

OR

See Also
Adding an Expression in Visualizer
Logical Query Language Functions