Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. 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