Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
does this apply when users are seeing the document on server via browser?