Missing values are being replaced by '-' when exporting Pivot Table data to excelArticle Number: 000045564 | Last Modified: 2019/01/24
Pivot table with missing values, shows '-' if the option "Populate Missing Cells" is selected in Presentation tab, under properties menu.
If the option "Populate Missing Cells" is not selected, the cells are showed as null.
Having any of these options selected, will no prevent the export to excel feature to export null values as '-'.
The behavior described is a BUG and will be fixed in QlikView version 12.20 SR3.
The BUG ID is QV-13046.
The resolution of this BUG is the installation of QlikView 12.20 SR3 release.
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.Submit a case
Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.