topic export to excel (date fields problem) in QlikView

export to excel (date fields problem)

ali_hijazi — Thu, 17 Sep 2015 07:00:51 GMT

Hello

Got a pivot table and I'm reading rows in which there is a field which is originally a string column but in fact the values are dates

I'm reading into QlikView and converting that column into date using the following:

num(DayStart(Date#(Field, 'DD MM YYYY')))

reading is fine however when users export the pivot table into excel this field is exported fine and is read the same way it is displayed in Qlik but the format is CUSTOM not DATE

Users want the format exported to Excel to be DATE and not CUSTOM

Please advise

Re: export to excel (date fields problem)

tresB — Thu, 17 Sep 2015 07:08:42 GMT

Try:

Go to Help tab->Click on About Qlikview (You get new window)->right click on Qlikview Icon (left bottom)->You get setting window->select ExcelExportMixedAsText->set its value to 0 from 1

Or might try full table export: Re: Wrong date format when export to Excel

Re: export to excel (date fields problem)

ali_hijazi — Thu, 17 Sep 2015 07:17:40 GMT

does this apply when users are seeing the document on server via browser?