topic Need help in using IN function in QlikView https://community.qlik.com/t5/QlikView/Need-help-in-using-IN-function/m-p/459689#M171595 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Is it possible to use the IN fuction when loading a QVD.</P><P></P><P>When I try to use the IN function in the Where conditon its showing error.</P><P></P><P>Please advise...</P><P></P><P>Regards</P><P></P><P>Chriss</P></BODY></HTML> Tue, 11 Jun 2013 10:41:10 GMT 2013-06-11T10:41:10Z Need help in using IN function https://community.qlik.com/t5/QlikView/Need-help-in-using-IN-function/m-p/459689#M171595 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Is it possible to use the IN fuction when loading a QVD.</P><P></P><P>When I try to use the IN function in the Where conditon its showing error.</P><P></P><P>Please advise...</P><P></P><P>Regards</P><P></P><P>Chriss</P></BODY></HTML> Tue, 11 Jun 2013 10:41:10 GMT https://community.qlik.com/t5/QlikView/Need-help-in-using-IN-function/m-p/459689#M171595 2013-06-11T10:41:10Z Re: Need help in using IN function https://community.qlik.com/t5/QlikView/Need-help-in-using-IN-function/m-p/459690#M171596 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>The QV script equivalent is Match(), eg </P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Where City In&nbsp; ('Cape Town', 'Johannesburg', 'Harare')</P><P></P><P><SPAN style="font-size: 10pt;">codes in QV like this:</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Where Match(City, 'Cape Town', 'Johannesburg', 'Harare')</P><P></P><P>Hope that helps</P><P>Jonathan</P></BODY></HTML> Tue, 11 Jun 2013 10:46:35 GMT https://community.qlik.com/t5/QlikView/Need-help-in-using-IN-function/m-p/459690#M171596 jonathandienst 2013-06-11T10:46:35Z Re: Need help in using IN function https://community.qlik.com/t5/QlikView/Need-help-in-using-IN-function/m-p/459691#M171597 <HTML><HEAD></HEAD><BODY><P>Excellent Jonathan,</P><P></P><P>It works......</P></BODY></HTML> Tue, 11 Jun 2013 12:59:01 GMT https://community.qlik.com/t5/QlikView/Need-help-in-using-IN-function/m-p/459691#M171597 2013-06-11T12:59:01Z