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 | ||||||||||||||||||||
| ||||||||||||||||||||
|