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 statements for multiple values

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

1 Solution

Accepted Solutions
jyothish8807
Master II
Master II

Hi,

try

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

Regards

KC

Best Regards,
KC

View solution in original post

1 Reply
jyothish8807
Master II
Master II

Hi,

try

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

Regards

KC

Best Regards,
KC