if condition for mutiple values in field

[stonecold111]

if(field1='colr code','freq data' and field2='group', 'pqr',abc')

how to write this in qlikview

i want multiple selections for the first field i mean field1

[Anil_Babu_Samineni]

May be this?

if(Match(field1, 'colr code','freq data') and Match(field2, 'group', 'pqr',abc'), 'Yes', 'No')

[Sergey_Shuklin · Accepted solution]

Hello, Suresh!

Try to use "or": =if((field1='val1' or field1='val2' or field1='val3') and field2='val1','A','B')

[stonecold111]

not working . i dont know why

[stonecold111]

working .. thank you

[Anil_Babu_Samineni]

May be you need condition as either this or that. That is the case it should work

[stonecold111]

if it matches means it returns 1 or 2 or 3

so i think i you need to give if(match(.....)>0

am i right??