Qlik Community

Ask a Question

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Join us March 10th, 7 Ways Modern Analytics Can Help You Take Smarter Action. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
david_pearson
Contributor III
Contributor III

NPrinting Excel Pivot Field Collapse Fully not working

Hi All

i have just started to create a report with Nprinitng, April 2019. i'm using Excel as the template. i have decided to create some of the charts using pivot tables within the excel template using a datatable i have brought in from my Qlik Sense app using Nprinting Tables function. 

My question is how do i create a pivot table with to row labels that stays collapsed when i preview the report? i have tried to select Collapse Entire Field in the template (see below image) but when this is previewed in Xlsx it shows them as expanded fully....

clipboard_image_0.png

 

Thanks

Labels (1)
3 Replies
Ruggero_Piccoli
Employee
Employee

Hi,

I suggest you to:

- create an Excel with macro template and associate the macro to the opening event. The macro will collapse the field

- send a support ticket with the request to add this improvement. I think right now pivot tables are always produced expanded

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
Daniel_Jenkins
Support
Support

Hi @david_pearson ,

Here is an example of what Ruggero is proposing you do. 

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/collapse-rows-in-excel-pivot-table-Nprintin...

HTH - Daniel.

Ruggero_Piccoli
Employee
Employee

Thanks @Daniel_Jenkins !

I would like to suggest you to add this to an article, I think it will be useful and more easy to be found 🙂



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.