Discussion Board for collaboration on QlikView Scripting.
When I export data to excel the date format is not kept the same as in the Qlikview model. I have my SET DateFormat='MMM-YY';, but when it exports to excel it exports as "dd-mmm" format.
However, if I export for a few months which is less data it exports fine, but once i export for more months which is more data (more records), it exports as "dd-mmm" format !
Anyway around this to be exported in the same format as the model which is "MMM-YY"??
Try this for your date field,
This is my scrip below, where would I place your recommendation scrip?
I have also did screen shots of the Model, the date format in the Model is correct, but when I export the data to excel, csv, it exports in the date format as dd-mmm. This only happens when I export for many records of data. I have read the "Wrong date format when export to Excel" stream no soluton cn be derived from this one so as the one from stigchel.
FOR EACH vSheet IN '[Secondary FY14]','[Secondary FY15]','[Secondary FY16]','[Secondary FY17]','[Primary FY14]','[Primary FY15]','[Primary FY16]','[Primary FY17]'
[SSD Suppliers_Primary Wholesalers],
[SSD Customer Name_Primary Ship-to],
[Self Care Territory],
[RX RSM Region],
[Self Care RSM Region],
[SSD Adj Value (SEP)],
(ooxml, embedded labels, table is $(vSheet));
check like this using,
Date(Date#(Month,'MMM-YY'),'MMM-YY') as Month
At Month field in your script.
You have two options: