If
Evaluates a logical expression, returning the one result if true, or another if false.
- Returned Output: Variant
- Library: PQL \ Common \ Logical
- Version: 2018.00.000
- Compatibility:
- Can be combined with and other PQL function throughout the application.
- It CANNOT be used with MDX or VBA functions. But it can be used on MDX-based content in other parts of the application.
Syntax
* Click on the function's arguments above for more details on the input values.
Comments
- The criteria expression is a logical statement that evaluates to true or false
- Outcomes can be alphanumeric ("variant") values or embedded functions that resolve to values.
Different Function types
Examples
This example checks if 2 is greater than 1. If it is, it returns 3 otherwise 4. In this case, it returns true - so 3.
If( 2>1, 3, 4 )
This example uses the dynamic grid below.
If( data(0,0)>= average(dataSetColumn(0)), "We're doing well", "We're doing badly" )
The logical expression check if data point (0,0) is greater than or equal to the average of the values in column 0. So it compares 19.36% to the average of net margin across all cells. Since the statement turns out to be false, the function resolves to "We're doing badly".