if condition in the set analysis - Qlik Community

mario-sarkis · ‎2016-02-13

hi All,

Here is my case:

i have a chart i am using the if condition but the problem is the chart calculation only take into consideration only the else expression:

Example:

case 1 :

if(condition,expression 1,expression 2) it take expression 2

case 2:

if(condition,expression 2,expression 1) it take expression 1

can anyone help?

Thank you.

swuehl · ‎2016-02-13

Can your condition be unambiguously evaluated in the scope you are using it?

For example, if you test on field values, is the field value unique in this scope?

A common mistake is something like

=If( Customer = 'Stefan', Expression1, Expression2)

in a table chart, but without using Customer as dimension. So 'Customer' is not unique in the context it's evaluated (assuming you have more than 1 customer).

edit: