topic Re: Unable to export Date fields in QlikView

Unable to export Date fields

debashisamant — Sat, 16 Nov 2024 04:24:56 GMT

Hi All,

While I am exporting my date fields (or number fields) in qlikview ,they are getting converted to text in the excel file.Is there any way we can fix this.

For number fields ,if we use round() function in expression , they appear as numbers in the exported excel.Is there any cheat available for date fields as well, for exporting them as dates(and not as text).We are using QlikView 12.

Thanks in advance

Re: Unable to export Date fields

tincholiver — Mon, 18 Feb 2019 23:52:17 GMT

Did you try formatting it from the number flap?
there you can tell him that numerical format has that expression

Re: Unable to export Date fields

debashisamant — Tue, 19 Feb 2019 05:32:52 GMT

Hii Tincholiver,

Thanks for the suggestion,but we are having our date fields in the dimensions in the Qlik charts.And our management don't wish to use excel to format the dates .They wish the output from Qlik should be, by default in date format.

Please tell me if I got your thoughts correctly.

Re: Unable to export Date fields

tincholiver — Tue, 19 Feb 2019 14:18:50 GMT

Can you upload a table with some record with date format datebase and how in excel is downloadaded?