topic Re: Nprinting - 3 pivot tables with the same dimensions in Qlik NPrinting

Nprinting - 3 pivot tables with the same dimensions

AlbRodero — Wed, 15 Sep 2021 17:03:45 GMT

Hello,

I am trying to create an xlsx report with three native pivot tables. I can't have a single big table, due to the nature of the data.

They work well independently, but I need to set them one after the other to make the illusion of a single table.

I have two challenges

Hide the Dimension column of the tables 2 and 3
Table 1 always has the same columns but table 2 can have more or less columns depending on selections and need to adjust the start of table 3 to begin right after table 2.

Thanks in advance

Frank_S — Wed, 15 Sep 2021 17:31:09 GMT

Can you provide a mock up of the result you are trying to achieve?

AlbRodero — Wed, 15 Sep 2021 17:53:45 GMT

I got to merge together table 2 and 3 so point 2 is fixed

I need to hide the Dimension column of table 2.

In the attach you can see the desired outcome and below the result so far

Thanks

Frank_S — Wed, 15 Sep 2021 18:38:20 GMT

Try this. It's an old video with NPrinting 16 as the designer but the design principle is the same.

(Note: You'll need to make a copy of your pivot table and convert it to a straight table and use the straight table for the cell by cell report.)

KInd regards...