Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

gibsontk1
New Contributor II

Split up an Excel pivot table based on field, similar to a page

Hey there, I'm trying to figure this out but I'm stuck. I'm attempting to generate an Excel pivot table that lists out a count of values per person on a month to month basis. My goal is to generate a sheet for each person, with each sheet containing the pivot table for the respective person and their counts.

If I try adding the person field as a page, I get the sheets for each person, but each pivot table contains all possible values. I've also tried adding the person field as a filter in the pivot table and using the "Show Report Filter Pages" option in Excel but that didn't seem to help much either. Not really sure what else to try at this point.

1 Solution

Accepted Solutions
Not applicable

Re: Split up an Excel pivot table based on field, similar to a page

There's no easy way to do this.

Will almost certainly require macros on a second workbook which references the NPrinting report.

Best

Aran

4 Replies
vvira1316
Valued Contributor II

Re: Split up an Excel pivot table based on field, similar to a page

Would you consider using a macro? If your can use macro then it may be possible.

Following link may provide some insight and help

Macro to Export Multiple Object into Multiple sheet loop by Field and store it into paritcular Locat...

gibsontk1
New Contributor II

Re: Split up an Excel pivot table based on field, similar to a page

Sorry, forgot to mention the source table is coming from Qlik Sense, so no macros on that side . I'd like to avoid using Excel macros if possible, due to possible security concerns from the report recipients, but I'm open to ideas if there's no other option.

Not applicable

Re: Split up an Excel pivot table based on field, similar to a page

There's no easy way to do this.

Will almost certainly require macros on a second workbook which references the NPrinting report.

Best

Aran

gibsontk1
New Contributor II

Re: Split up an Excel pivot table based on field, similar to a page

Thanks! Sounds like more trouble than it's worth, so I'll look into alternatives.

Community Browser