Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
pauldamen
Partner
Partner

Using OR function in Qlikview

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Try either

=if ( Month = 'Jan' or Month = ' Feb' or Month = 'Mar', text1, text2)

or

=if ( match(Month,'Jan',' Feb', 'Mar'), text1, text2)

View solution in original post

1 Reply
swuehl
MVP
MVP

Try either

=if ( Month = 'Jan' or Month = ' Feb' or Month = 'Mar', text1, text2)

or

=if ( match(Month,'Jan',' Feb', 'Mar'), text1, text2)