Qlik Sense Business may experience unexpected behavior when exporting to Excel. The behavior may not be aligned with the export features as seen in Qlik Sense Enterprise.
Pivot Tables export fully expanded
Pivot tables will export fully expanded. This is working as designed.
Wrong format on export of Pivot Tables
Exporting a visualization leads to number columns being formatted as text. This has been resolved for Straight Tables. This has been resolved. Update to the latest version.
Pivot Tables are exported as expanded tables
This is working as designed.
Environment:
Qlik Sense Business
Cause & Resolution:
Internal Reference IDs:
- Feature Request 3067 - Make Exported Excel files from Qlik Sense Business the same as Qlik Sense Business or Qlik Sense Enterprise on Windows
- Feature Request 3134 - Only Export what is shown in the pivot table for Qlik Sense Business
- REPSVC-601: Qlik Sense Business - Pivot Table is always being exported as expanded table and generates error