Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Store in to different sheets

Hi

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?

2 Replies
Not applicable
Author

You can store into (txt) format, but there is very little control over the format of the file. 

From the help file:

format-spec ::= ( ( txt | qvd ) )
The format specification consists of a the text txt for text files, or the text qvd for qvd files. If the format specification is omitted, qvd is assumed.

Please vote on this idea if you would like to see more format options:

http://community.qlik.com/ideas/2021

marcus_sommer

Perhaps an alternative could be to store with macros per GUI if the amount of data isn't too big.

- Marcus