topic Using OR function in Qlikview in QlikView https://community.qlik.com/t5/QlikView/Using-OR-function-in-Qlikview/m-p/366881#M573762 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>I am trying to us the OR function in Qlikview. My formula looks like this:</P><P></P><P>=if ( Month = 'Jan' or ' Feb' or 'Mar', text1, text2)</P><P></P><P>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.</P><P></P><P>Could someone help?</P><P></P><P>Regards,</P><P>Paul</P></BODY></HTML> Wed, 25 Jul 2012 09:59:23 GMT pauldamen 2012-07-25T09:59:23Z Using OR function in Qlikview https://community.qlik.com/t5/QlikView/Using-OR-function-in-Qlikview/m-p/366881#M573762 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>I am trying to us the OR function in Qlikview. My formula looks like this:</P><P></P><P>=if ( Month = 'Jan' or ' Feb' or 'Mar', text1, text2)</P><P></P><P>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.</P><P></P><P>Could someone help?</P><P></P><P>Regards,</P><P>Paul</P></BODY></HTML> Wed, 25 Jul 2012 09:59:23 GMT https://community.qlik.com/t5/QlikView/Using-OR-function-in-Qlikview/m-p/366881#M573762 pauldamen 2012-07-25T09:59:23Z Re: Using OR function in Qlikview https://community.qlik.com/t5/QlikView/Using-OR-function-in-Qlikview/m-p/366882#M573763 <HTML><HEAD></HEAD><BODY><P>Try either</P><P></P><P><EM>=if ( Month = 'Jan' or Month = ' Feb' or Month = 'Mar', text1, text2)</EM></P><P></P><P>or </P><P></P><P><EM>=if ( match(Month,'Jan',' Feb', 'Mar'), text1, text2)</EM></P></BODY></HTML> Wed, 25 Jul 2012 10:10:01 GMT https://community.qlik.com/t5/QlikView/Using-OR-function-in-Qlikview/m-p/366882#M573763 swuehl 2012-07-25T10:10:01Z