Discussion Board for collaboration on QlikView Scripting.
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
if ( = and = , 1 , 0 ) ) as
Try to load like this
if( (B=C),1,0)) as D, A,B,C;
LOAD * Inline
And change value according to result
Oh i am sorry actually write And
if( (A=B) And (B=C),1,0) as D
-(A=B And B=C) as D