topic Store in QlikView https://community.qlik.com/t5/QlikView/Store/m-p/142229#M21756 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>is it possible to use store with where statements? and if it is, how is it used? can't seem to find anything in the help files..</P><P>Regards,<BR />Kjetil</P></BODY></HTML> Thu, 23 Apr 2009 20:43:25 GMT 2009-04-23T20:43:25Z Store https://community.qlik.com/t5/QlikView/Store/m-p/142229#M21756 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>is it possible to use store with where statements? and if it is, how is it used? can't seem to find anything in the help files..</P><P>Regards,<BR />Kjetil</P></BODY></HTML> Thu, 23 Apr 2009 20:43:25 GMT https://community.qlik.com/t5/QlikView/Store/m-p/142229#M21756 2009-04-23T20:43:25Z Store https://community.qlik.com/t5/QlikView/Store/m-p/142230#M21757 <HTML><HEAD></HEAD><BODY><P>No, the syntax of Store doesn't include "where" clause. You can first load a separate table (remember to use NOCONCATENATE if you are loading exactly the same fields) with applied selection, and then store that table. For example:</P><P>OriginalTable:</P><P>load</P><P>A,B,C</P><P>from ...</P><P></P><P>LimitedTable:</P><P>NOCONCATENATE Load * resident OriginalTable where A&gt;0;</P><P>store LimitedTable into myQVD.QVD;</P><P>drop table LimitedTable;</P><P></P><P>hope it helps,</P><P>Oleg</P></BODY></HTML> Thu, 23 Apr 2009 22:14:28 GMT https://community.qlik.com/t5/QlikView/Store/m-p/142230#M21757 Oleg_Troyansky 2009-04-23T22:14:28Z