topic if condition in the set analysis in QlikView

if condition in the set analysis

mario-sarkis — Sat, 13 Feb 2016 16:38:14 GMT

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.

Re: if condition in the set analysis

swuehl — Sat, 13 Feb 2016 16:44:22 GMT

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:

Re: if condition in the set analysis

sunny_talwar — Sat, 13 Feb 2016 16:55:48 GMT

Difficult to comment before looking at it. Is it possible to share a sample?