Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I am trying to us the OR function in Qlikview. My formula looks like this:
=if ( Month = 'Jan' or ' Feb' or 'Mar', text1, text2)
It doesn't give me an error but it is not showing me the correct answers. I tried putting the or in front of month between brackets but that doesn't help either.
Could someone help?
Regards,
Paul
Try either
=if ( Month = 'Jan' or Month = ' Feb' or Month = 'Mar', text1, text2)
or
=if ( match(Month,'Jan',' Feb', 'Mar'), text1, text2)
Try either
=if ( Month = 'Jan' or Month = ' Feb' or Month = 'Mar', text1, text2)
or
=if ( match(Month,'Jan',' Feb', 'Mar'), text1, text2)