I need help understanding how the DATA HANDLING - CALCULATION CONDITION of a chart works in Qlik Sense.
I have a table with a dimension calculated as follow:
=if((A) <= B,'OK','ATTENTION') as "A <= B"
and I need to write a condition that displays the table only when "A <= B" = 'ATTENTION' and if the condition is not satisfied want to display a message. This condition ("A <= B" = 'ATTENTION') is not working, can someone please help me with this? Thanks
The calculation Condition is used to determine whether or not an object (e.g. chart) is to be displayed.
If you are trying to display only records with the value "ATTENTION", set analysis could help you.
Link to a post, where a similar question was solved:
Hope this helps,
Instead of using calculation condition (which provides 2 options: display / not display all table values based on the result of the calculation), I would suggest to try defining the value of e.g. expression A in this way: if(A<=B,A,null()) .
Then if you turn off showing null values for this dimension (Uncheck Include null values), you will see only the values, that satisfy your condition.
The other option is to use set analysis in defining your dimensions / expressions.