Date or other dual dimensions are not exported correctly in Excel
Article Number: 000052828 | Last Modified: 2019/12/19
When a table containing dual dimesions values (like date) is exported , Excel shows incorrect or non exixting data in the columns corresponding to those dimensions.
- QlikView all versions
- Qlik Sense all versions
- Excel all version
The problem is due to a known limitation: Excel cannot correctly manage QlikView dual fields, like date.
Dual fields are fields of data that have two different representations. A typical example is Dates.
Dates is a numerical field, this means that a single numerical value is given to each date when it is stored in QlikView.
For example, you can easily see the numeric value of today if you use a formula like num(date(today())).
On the other side, dates has also a string representation that is used to show the date in a readable format.
The problem is that Excel cannot manage this double values and by default associate to each date coming from QlikView his numerical value.
The problem depends on the fact that Excel cannot manage QlikView date correctly, and cannot be solved from our side.
The best would be to use NPrinting to create Excel report. NPrinting forces a correct conversion of the date fields and show dates in the correct format.