Multiple Condition not working in Formula

[luzu]

Hello, 

I am trying to create a where clause with multiple conditions (See Below), it is not working, I am not sure why it isn't working, any ideas? 

where MGTRTP = ('GPT' or 'MOV' or 'CLM' or 'NE1' or 'NE2' or 'PO1' or 'WON' or 'WOP' or 'Y05' or 'Y06') ;

[Sayed_Mannan · Accepted solution]

The issue here is with the syntax of your `WHERE` clause.

In Qlik Sense, when you want to match a field with multiple values, you should use the Match function. Here's how you can modify your `WHERE` clause:

WHERE Match(MGTRTP, 'GPT', 'MOV', 'CLM', 'NE1', 'NE2', 'PO1', 'WON', 'WOP', 'Y05', 'Y06');

This will select rows where `MGTRTP` matches any of the values listed in the `Match` function.

Let me know if this helps!

[Anil_Babu_Samineni · Accepted solution]

This way it won't work. You need to do like this

where MGTRTP = 'GPT' or MGTRTP = 'MOV' or MGTRTP = 'CLM' .......;

[luzu]

Thank you!