topic Re: Separate Page with corresponding data per the dimension not working with Pivot Table in Qlik NPrinting

Separate Page with corresponding data per the dimension not working with Pivot Table

TDQlik — Fri, 15 Nov 2024 21:47:18 GMT

Hi again,

I am using a Pivot table as per necessity of the requirement and 'd like to configure my NP report to show the data it's splitting per page by using Pages. I have read all over the forum that levels don't work with pivot tables, but does that also extend to Pages? I have my pivot table ready I've set the Page to the dimension it needs to split, it works nicely but it totals all values together for each page instead of giving the value for that particular value of that dimension.

I read in another post that it's possible to add the column it needs to split by as the first column in the pivot but that's not how the report should work - the split by dimension should not be inside the pivot table but simply 1 pivot table per value of the dimension used in the Page.

Hope the information is sufficient - any direction and guidance is appreciated. Thanks! 🙂

Best,

Re: Separate Page with corresponding data per the dimension not working with Pivot Table

Ruggero_Piccoli — Tue, 28 Feb 2023 13:51:53 GMT

Hi,

Native Excel Pivot tables works in combiation with Pages. Please the table used as source of data for the pivot in the same worksheet. Be sure you did all the steps in https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/ExcelReports/Pivot-table-Excel.htm including the one needed to update the pivot data on opening.

Best Regards,

Ruggero

Re: Separate Page with corresponding data per the dimension not working with Pivot Table

TDQlik — Tue, 28 Feb 2023 14:18:49 GMT

Hi Ruggero,

Thanks for your reply - that documentation I've followed without the desired result I'm afraid. I've even started from scratch again, just to ensure I haven't compounded small mistakes. I'm following that tutorial, both with and without the level version. The moment I add the Page I get 3 separate pages for the values but all of them contain the exact same data (all of their data summed together).

Any other ideas perhaps? Using NP May 2022 version - I have filtered on those 3 values to compress the data, because there are roughly 50 in it.

Re: Separate Page with corresponding data per the dimension not working with Pivot Table

Ruggero_Piccoli — Tue, 28 Feb 2023 15:02:02 GMT

Hi,

That was an issue solver in February 2019. You are using a more recent version so it should work. I tried on a May 2022 SR4 installation and it works correctly.

This is my template:

Remember to change those settings:

If you can please share some screenshots of your template.

Best Regards,

Ruggero

Re: Separate Page with corresponding data per the dimension not working with Pivot Table

Lech_Miszkiewicz — Tue, 28 Feb 2023 22:55:06 GMT

The moment I add the Page I get 3 separate pages for the values but all of them contain the exact same data (all of their data summed together).

Your above sentence indicates to me 1 of 2 possible issues:

your page field is unrelated to data model
you are putting source of your pivot table outside of the sheet where pivot table is placed (it must be in the same sheet!)

cheers

Re: Separate Page with corresponding data per the dimension not working with Pivot Table

TDQlik — Wed, 01 Mar 2023 08:52:00 GMT

Hi both,

You are 100% right Lech, it's my data table being in a separate sheet and Ruggero said it in his first reply too, but I may have overlooked it - I did not realize it was key for the data table to be in the same worksheet, I've always separated the two. I guess Pages in NPrinting requires it. Thanks for your input gentlemen, I will flag Ruggero's response as the solution due to it containing the message of keeping the data table in the same worksheet.

Though, this is not mentioned in the documentation as it's not concerning Pages, perhaps something to add?

Re: Separate Page with corresponding data per the dimension not working with Pivot Table

Ruggero_Piccoli — Wed, 01 Mar 2023 09:51:31 GMT

Hi,

This suggestion can be added in the help site.

If you add the source table in a worksheet that is not paged they will not be filtered by the entity added in the Pages node because the worksheet is not paged.

Instead adding a field or a straight table in the Pages node means data in each generated worksheet will be filtered for that entity.

In other words Pages, Levels and Cycles are filters.

Best Regards,

Ruggero