IF
Description
Warning
The IF
operator can currently only be used within Analysis.
IF
evaluates a list of static conditions and replaces itself with the query for the first static condition that is true.
Syntax
IF static_condition THEN calculation [ ELSE IF condition THEN calculation ]* [ ELSE calculation ] END
In contrast to STATIC CASE WHEN, an IF
query does not require an ELSE
. Not specifying an ELSE
in an IF
results in an empty PQL query if none of the static conditions are met.
NULL handling
If a static condition evaluates to NULL, it is treated as if it was false.
Examples
[1] In this example, we use | ||||||||||||||||||||
| ||||||||||||||||||||
|