topic Re: If statements for multiple values in QlikView https://community.qlik.com/t5/QlikView/If-statements-for-multiple-values/m-p/659683#M538012 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>try</P><P>if(match(Field,'1','3','4','7'),'x',if(match(Field,'2','5','6'),'y',''))</P><P></P><P>Regards</P><P>KC</P></BODY></HTML> Sun, 05 Oct 2014 09:57:52 GMT jyothish8807 2014-10-05T09:57:52Z If statements for multiple values https://community.qlik.com/t5/QlikView/If-statements-for-multiple-values/m-p/659682#M538011 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I'm trying to write below in Qlikview load script can anyone help me on this?</P><P></P><P>Case when FIELD 1 IN (1,3,4,7) THEN X</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; when FIELD 1 in (2,5,6) THEN Y ELSE ' '&nbsp; END</P><P></P><P>Thanks</P></BODY></HTML> Sun, 05 Oct 2014 09:49:14 GMT https://community.qlik.com/t5/QlikView/If-statements-for-multiple-values/m-p/659682#M538011 2014-10-05T09:49:14Z Re: If statements for multiple values https://community.qlik.com/t5/QlikView/If-statements-for-multiple-values/m-p/659683#M538012 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>try</P><P>if(match(Field,'1','3','4','7'),'x',if(match(Field,'2','5','6'),'y',''))</P><P></P><P>Regards</P><P>KC</P></BODY></HTML> Sun, 05 Oct 2014 09:57:52 GMT https://community.qlik.com/t5/QlikView/If-statements-for-multiple-values/m-p/659683#M538012 jyothish8807 2014-10-05T09:57:52Z