topic Re: Excel Pivot tables - collapsed rows in Qlik NPrinting

Excel Pivot tables - collapsed rows

stig1984 — Sat, 16 Nov 2024 05:11:23 GMT

Does anyone have a solution for NPrinting Sept 2018 onwards for how to default an excel pivot to have collapsed fields?

All the answers I have seen so far relate to options available in NP 16 for saving as xlsm and adding macros but removed from 17 on where these options are not available.

thanks,

Re: Excel Pivot tables - collapsed rows

chriswain2 — Tue, 20 Nov 2018 14:54:24 GMT

Hi, the functionality to use .xlsm templates is back in the latest version of NPrinting 17 - Sept 18.

Chris

Re: Excel Pivot tables - collapsed rows

Lech_Miszkiewicz — Tue, 20 Nov 2018 21:07:18 GMT

Agree with Chris - write macro.

regards

Lech

Re: Excel Pivot tables - collapsed rows

Daniel_Jenkins — Tue, 20 Nov 2018 22:13:56 GMT

Hi,

Here is an example: https://community.qlik.com/t5/Qlik-NPrinting-Discussions/collapse-rows-in-excel-pivot-table-Nprinting/td-p/1124165

HTH - Daniel.

Re: Excel Pivot tables - collapsed rows

stig1984 — Tue, 27 Nov 2018 11:03:14 GMT

Many thanks - got there in the end.