topic Re: IF statement... With two conditions in QlikView

IF statement... With two conditions

Fri, 27 Sep 2013 18:26:59 GMT

I want to use a IF Statement which has two conditions to satisfy and on the basis of the two conditions, it should return True or False.

I am using the following expression--->

=IF(age>30 AND Sal>200, 1,0)

however this returning me a False value even if Both the conditions are met !

Can someone tell me where am i going wrong ?

Re: IF statement... With two conditions

MayilVahanan — Fri, 27 Sep 2013 18:32:17 GMT

Can you provide a sample file? Without see that scenario, we can't able to give solution. Expression looks ok

Re: IF statement... With two conditions

jpapador — Fri, 27 Sep 2013 18:33:35 GMT

Instead of using AND trying using a nested if:

If(Age > 30,

If(Sal > 200, 1,0))

Re: IF statement... With two conditions

john_duffy — Fri, 27 Sep 2013 18:46:15 GMT

Hello.

The syntax of your if statement looks correct. I believe if the conditions are met and you want the result to represent 'true', you should replace 1 with -1.

John.

Re: IF statement... With two conditions

Fri, 27 Sep 2013 18:46:45 GMT

Thanks Jpapador !

It helped

so i want to aggregate the output of the IF condition on a Dimension, and Sum it based on the Dimension selected in the Dimension selection in charts

Something like this -->

=sum(Aggr(if(Age>30,

if(Sal>200,'1','0')),EMPID]))

---------------------------------------

Where i want to aggregate on EMPID and

Sum based on a Dimension lets say X

Any Idea how to go about it ?