Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

If(Field1 = A OR Field1 = B OR Field1 = C OR Field1 = D OR Field1 =..... , )

Is there an easier way of writing this?

If(Field1 = A OR Field1 = B OR Field1 = C OR Field1 = D OR Field1 =..... , )

I'd like to be able to write something like If(Field1 IN(A, B, C, D, E, F.....) , ).  I have a lot of acceptable values for Field1, and the actual field name and values are much longer strings

Thanks

1 Solution

Accepted Solutions
MayilVahanan

HI

Try like this

=If(Match(Field1,'A','B','C','D'),1, 0)

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

2 Replies
MayilVahanan

HI

Try like this

=If(Match(Field1,'A','B','C','D'),1, 0)

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

Maaaaatch, that's the function!  Thank you!