topic Re: Store in to different sheets in QlikView https://community.qlik.com/t5/QlikView/Store-in-to-different-sheets/m-p/451059#M700954 <HTML><HEAD></HEAD><BODY><P>Perhaps an alternative could be to store with macros per GUI if the amount of data isn't too big.</P><P></P><P>- Marcus</P></BODY></HTML> Fri, 16 Aug 2013 15:10:56 GMT marcus_sommer 2013-08-16T15:10:56Z Store in to different sheets https://community.qlik.com/t5/QlikView/Store-in-to-different-sheets/m-p/451057#M700952 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Is it possible to store in to different sheets when using the STORE in to .csv function? And is it possible to store in to standard Excel format?</P></BODY></HTML> Thu, 25 Oct 2012 07:34:44 GMT https://community.qlik.com/t5/QlikView/Store-in-to-different-sheets/m-p/451057#M700952 2012-10-25T07:34:44Z Re: Store in to different sheets https://community.qlik.com/t5/QlikView/Store-in-to-different-sheets/m-p/451058#M700953 <HTML><HEAD></HEAD><BODY><P>You can store into (txt) format, but there is very little control over the format of the file.&nbsp; </P><P></P><P>From the help file:</P><P></P><P><SPAN style="font-style: italic;">format-spec ::= </SPAN><SPAN class="Bold">(</SPAN><SPAN style="font-style: italic;"> ( </SPAN><SPAN class="Bold">txt</SPAN><SPAN style="font-style: italic;"> | </SPAN><SPAN class="Bold">qvd</SPAN><SPAN style="font-style: italic;"> ) </SPAN><SPAN class="Bold">)<BR /></SPAN>The format specification consists of a the text <SPAN class="Bold">txt</SPAN> for text files, or the text <SPAN class="Bold">qvd</SPAN> for qvd files. If the format specification is omitted, <SPAN class="Bold">qvd</SPAN> is assumed.</P><P></P><P>Please vote on this idea if you would like to see more format options:</P><P></P><P><A _jive_internal="true" class="loading" href="https://community.qlik.com/ideas/http://community.qlik.com/ideas/2021">http://community.qlik.com/ideas/2021</A></P></BODY></HTML> Fri, 16 Aug 2013 15:03:05 GMT https://community.qlik.com/t5/QlikView/Store-in-to-different-sheets/m-p/451058#M700953 2013-08-16T15:03:05Z Re: Store in to different sheets https://community.qlik.com/t5/QlikView/Store-in-to-different-sheets/m-p/451059#M700954 <HTML><HEAD></HEAD><BODY><P>Perhaps an alternative could be to store with macros per GUI if the amount of data isn't too big.</P><P></P><P>- Marcus</P></BODY></HTML> Fri, 16 Aug 2013 15:10:56 GMT https://community.qlik.com/t5/QlikView/Store-in-to-different-sheets/m-p/451059#M700954 marcus_sommer 2013-08-16T15:10:56Z