topic If And Statement in Script in QlikView

If And Statement in Script

Mon, 08 Dec 2014 17:58:39 GMT

Hello,

I would like to create the equivalent of an If(And()) statement, as seen in Excel, in the QV script.

I would like an output of '1' if column A = column B = column C, and an output of '0' if this is not true. I imagine the syntax would be something like the following, but haven't got it quite right:

if( = ,if ( = ,1,0)) as

Any thoughts?

Thank you!

Re: If And Statement in Script

Anonymous — Mon, 08 Dec 2014 18:03:42 GMT

if ( = and = , 1 , 0 ) ) as

Re: If And Statement in Script

its_anandrjs — Mon, 08 Dec 2014 18:06:35 GMT

Hi,

Try to load like this

LOAD

iF( (A=B),1,

if( (B=C),1,0)) as D, A,B,C;

LOAD * Inline

[

A,B,C

1,1,1

];

And change value according to result

Regards

Anand

Re: If And Statement in Script

its_anandrjs — Mon, 08 Dec 2014 18:11:51 GMT

Oh i am sorry actually write And

if( (A=B) And (B=C),1,0) as D

Regards

Anand

Re: If And Statement in Script

MarcoWedel — Mon, 08 Dec 2014 18:21:22 GMT

-(A=B And B=C) as D