Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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

View solution in original post