Date Dual Field exported in Excel as numeric value instead of text value as in previous QlikView Versions
Article Number: 000060295 | Last Modified: 2019/01/14
When exporting to Excel from earlier QlikView versions the date dual field is exported as its corresponding Text Value, when exporting from a newer version the dual field is exported as numeric value.
The problem occurs when the dual formula for date values returns negative values, for example Jan=-363, Feb=-332. The Excel file at first sigh shows #### when the cell is selected it is possible to see the negative numeric value.
QlikView 12.20 SR5 (November 2017)
This is an intentional change in behavior where the QlikEngine is more effective with identifying, establishing and maintaining date formats. However, this increased awareness assumes that all dates are properly established and that they are a valid interpretation of either a date or the corresponding raw numeric format.
R&D determined this to be working as designed.
It is possible (and recommended) to use the text() function in order to display the text string interpretation of the value rather than the actual numeric value, in order to mimic the older behavior.
The recommendation is that a valid underlying numeric format is properly established when using dual formats.
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.