topic Re: Store and Where in QlikView https://community.qlik.com/t5/QlikView/Store-and-Where/m-p/555051#M207352 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>No, it's not possible.</P><P></P><P>The only way is to:</P><UL><LI>create a new table (use NoConcatenate) with the WHERE clause</LI><LI>store it</LI><LI>drop the created table</LI></UL></BODY></HTML> Mon, 14 Oct 2013 13:38:24 GMT dvasseur 2013-10-14T13:38:24Z Store and Where https://community.qlik.com/t5/QlikView/Store-and-Where/m-p/555049#M207350 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P></P><P>Is it possible to "STORE" in order to create a QVD and limit records by a WHERE clause.</P></BODY></HTML> Mon, 14 Oct 2013 13:36:17 GMT https://community.qlik.com/t5/QlikView/Store-and-Where/m-p/555049#M207350 vivientexier 2013-10-14T13:36:17Z Re: Store and Where https://community.qlik.com/t5/QlikView/Store-and-Where/m-p/555050#M207351 <HTML><HEAD></HEAD><BODY><P>No.</P><P></P><P>Prepare and filter your RESIDENT table before you STORE it. However, you can omit or rename individual fields when storing a table.</P><P></P><P>Peter</P></BODY></HTML> Mon, 14 Oct 2013 13:37:52 GMT https://community.qlik.com/t5/QlikView/Store-and-Where/m-p/555050#M207351 Peter_Cammaert 2013-10-14T13:37:52Z Re: Store and Where https://community.qlik.com/t5/QlikView/Store-and-Where/m-p/555051#M207352 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>No, it's not possible.</P><P></P><P>The only way is to:</P><UL><LI>create a new table (use NoConcatenate) with the WHERE clause</LI><LI>store it</LI><LI>drop the created table</LI></UL></BODY></HTML> Mon, 14 Oct 2013 13:38:24 GMT https://community.qlik.com/t5/QlikView/Store-and-Where/m-p/555051#M207352 dvasseur 2013-10-14T13:38:24Z Re: Store and Where https://community.qlik.com/t5/QlikView/Store-and-Where/m-p/555052#M207353 <HTML><HEAD></HEAD><BODY><P>you store the loaded table, you can limit the store by reloading the wanted table to a temp table with a where <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">clause</SPAN> and then immediately dropping it when storing is done.</P></BODY></HTML> Mon, 14 Oct 2013 13:39:03 GMT https://community.qlik.com/t5/QlikView/Store-and-Where/m-p/555052#M207353 2013-10-14T13:39:03Z