topic SQL select in clause with a qvd load or resident load in QlikView https://community.qlik.com/t5/QlikView/SQL-select-in-clause-with-a-qvd-load-or-resident-load/m-p/350960#M130105 <HTML><HEAD></HEAD><BODY><P> I have tried to make that work before (and failed) and I do not believe there is an "IN" statement in QlikViews scripting.</P><P>Stephen</P></BODY></HTML> Mon, 14 May 2012 20:37:58 GMT 2012-05-14T20:37:58Z SQL select in clause with a qvd load or resident load https://community.qlik.com/t5/QlikView/SQL-select-in-clause-with-a-qvd-load-or-resident-load/m-p/350958#M130103 <HTML><HEAD></HEAD><BODY><P>HI All</P><P></P><P>How do I a IN criteria for a qvd file load or a resident load?</P><P></P><P>for example, in sql i can have something like select * from table where title IN (select name from table2 where name IN ('open', 'close', 'other')</P><P></P><P>Thanks</P></BODY></HTML> Mon, 14 May 2012 20:24:40 GMT https://community.qlik.com/t5/QlikView/SQL-select-in-clause-with-a-qvd-load-or-resident-load/m-p/350958#M130103 2012-05-14T20:24:40Z SQL select in clause with a qvd load or resident load https://community.qlik.com/t5/QlikView/SQL-select-in-clause-with-a-qvd-load-or-resident-load/m-p/350959#M130104 <HTML><HEAD></HEAD><BODY><P>You want to use the match() function - I did a blog post about it last weekend if it helps</P><P></P><P><A href="http://oneqlikatatime.blogspot.co.uk/2012/05/in-statements-in-qlikview-match.html">http://oneqlikatatime.blogspot.co.uk/2012/05/in-statements-in-qlikview-match.html</A></P><P></P><P>Chris</P></BODY></HTML> Mon, 14 May 2012 20:36:40 GMT https://community.qlik.com/t5/QlikView/SQL-select-in-clause-with-a-qvd-load-or-resident-load/m-p/350959#M130104 2012-05-14T20:36:40Z SQL select in clause with a qvd load or resident load https://community.qlik.com/t5/QlikView/SQL-select-in-clause-with-a-qvd-load-or-resident-load/m-p/350960#M130105 <HTML><HEAD></HEAD><BODY><P> I have tried to make that work before (and failed) and I do not believe there is an "IN" statement in QlikViews scripting.</P><P>Stephen</P></BODY></HTML> Mon, 14 May 2012 20:37:58 GMT https://community.qlik.com/t5/QlikView/SQL-select-in-clause-with-a-qvd-load-or-resident-load/m-p/350960#M130105 2012-05-14T20:37:58Z SQL select in clause with a qvd load or resident load https://community.qlik.com/t5/QlikView/SQL-select-in-clause-with-a-qvd-load-or-resident-load/m-p/350961#M130106 <HTML><HEAD></HEAD><BODY><P>Hi Stephen,</P><P></P><P>The match() function has a funny syntax but is definitely a comparative function to SQL in function.</P><P></P><P>Chris</P></BODY></HTML> Mon, 14 May 2012 20:40:20 GMT https://community.qlik.com/t5/QlikView/SQL-select-in-clause-with-a-qvd-load-or-resident-load/m-p/350961#M130106 2012-05-14T20:40:20Z SQL select in clause with a qvd load or resident load https://community.qlik.com/t5/QlikView/SQL-select-in-clause-with-a-qvd-load-or-resident-load/m-p/350962#M130107 <HTML><HEAD></HEAD><BODY><P> You are right, the match function does handle the "IN" funtionality.</P><P>Stephen</P></BODY></HTML> Mon, 14 May 2012 20:44:41 GMT https://community.qlik.com/t5/QlikView/SQL-select-in-clause-with-a-qvd-load-or-resident-load/m-p/350962#M130107 2012-05-14T20:44:41Z