topic OR logical function in QlikView

OR logical function

Anonymous — Tue, 10 May 2011 19:02:45 GMT

Is there an equivelent to the OR logical function?

Im trying to load a flag as to whether or not one field is equal to any of 3 seperate values.

If(X = 'a' or 'b' or 'c',1,0)as Flag, returns true for every record including those that = d, e, f, etc.

erichshiino — Tue, 10 May 2011 19:04:50 GMT

did you try to repeat the field on the conditon?

If(X = 'a' or X = 'b' or X = 'c',1,0)as Flag

Anonymous — Tue, 10 May 2011 19:09:03 GMT

thanks.

Anonymous — Wed, 11 May 2011 00:47:28 GMT

Same thing, different approach, I prefer it as a more flexible:

if(match(X,'a','b','c'),1,0)