Discussion Board for collaboration on QlikView Scripting.
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?
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:
Perhaps an alternative could be to store with macros per GUI if the amount of data isn't too big.