Find Answers
Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join Us
Knowledge
NPrinting Excel Pivot table are always expanded when generated
Article Number: 000086579 | Last Modified: 2019/10/28Description
When developing a pivot table using Excel as output in NPrinting, the pivot table is always expanded. Is it possible to generate a compressed Pivot table?
Environment
Environment
- NPrinting all releases
Cause
The generation of pivot tables is based on Excel features that NPrinting just uses during the report generation. In fact, the impossibility to create a collapsed Pivot table by default is due to an Excel limitation. So far, there is not an Excel property that we can apply to a pivot table to automatically collapse it. We can only manually collapse single entries or fields.
You can find many references about this in internet, for example here.
Resolution
So, we expect that Pivot tables are always expanded when they are generated.
If collapsed pivot tables are needed, it is possible to try with a macro: in this case, consider that Macro can be used with NPrinting, but Qlik support is not responsible for their implementation.
Get Answers
Find Answers
Get Support
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.
Submit a case
Talk with a Representative
Critical Issues
Experiencing a serious issue, please contact us by phone. For Data Integration related issues please refer to your onboarding documentation for current phone number.
Call Us