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!
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.
