Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Join us for live office hours! Q&A with Qlik on Dec 14 at 10am EST: Refining Reports and Visualizations
cancel
Showing results for 
Search instead for 
Did you mean: 
markodonovan
Specialist
Specialist

Nprinting 16 - Pivot tables on Multiple Worksheets

Hi all,

I'm trying to create 1 pivot table on separate worksheets, 1 per region.

The source data is in 1 worksheet.

I have added a page to the sheet that contains the pivot table.

Now I would like to filter the pivot table by region.

Is there a simple way to do this ?

Would have been nice if the Excel 'Show Filter Report Pages...' worked.

When I try to put the data in the same worksheet as the pivot table I get a 'Reference is not valid' error.

Thanks

Mark

1 Solution

Accepted Solutions
Not applicable

Mark,

I don't think what you're trying to do is possible without marcos/scripting.

NPrinting can parse the data sets on different worksheets using the "Page" feature, but it's not possible to put the Excel pivot table on the same worksheet as the source data.

You could probably write a macro which would take that worksheet and the build pivot table(s) based on the discrete data sets on each worksheet in the report.

I can't think of any other way of doing this.

Best

Aran

View solution in original post

2 Replies
Not applicable

Mark,

I don't think what you're trying to do is possible without marcos/scripting.

NPrinting can parse the data sets on different worksheets using the "Page" feature, but it's not possible to put the Excel pivot table on the same worksheet as the source data.

You could probably write a macro which would take that worksheet and the build pivot table(s) based on the discrete data sets on each worksheet in the report.

I can't think of any other way of doing this.

Best

Aran

View solution in original post

markodonovan
Specialist
Specialist
Author

Thanks for the reply Aran,

I was just hoping there was something I was missing.

Mark