If statements for multiple values

[#1]

Hello,

I'm trying to write below in Qlikview load script can anyone help me on this?

Case when FIELD 1 IN (1,3,4,7) THEN X

         when FIELD 1 in (2,5,6) THEN Y ELSE ' '  END

Thanks

[jyothish8807 · Accepted solution]

Hi,

try

if(match(Field,'1','3','4','7'),'x',if(match(Field,'2','5','6'),'y',''))

Regards

KC