Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Store in to different sheets


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

Re: Store in to different sheets

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:


Re: Store in to different sheets

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

- Marcus

Community Browser