The exported date is not in date format.

RayWu — Sat, 16 Nov 2024 04:10:29 GMT

I export data in the app of qliksense. The data file is in Excel format, and the date is displayed in Excel as a string of numbers rather than a date format.

Please tell me how to make it display date format, thank you!

Re: The exported date is not in date format.

jaibau1993 — Tue, 05 Nov 2019 10:59:23 GMT

Hi!

As youmay know, dates in Qlik are Dual data, it is, dates have two components: the numeric one (with a value around 43000 for current dates) and a text one (the format, 01/01/2019).

In order to export the chart to Excel, you may use Text(Date) as the chart dimension instead of Date. You can create this field in the script too so you avoid the use of a calculated dimension.

Regards,

Jaime.

topic The exported date is not in date format. in App Development

The exported date is not in date format.

Re: The exported date is not in date format.