topic Re: Nprinting Pixelperfect Total (Sum, Avg, Max, Count,...) not working in Qlik NPrinting

Nprinting Pixelperfect Total (Sum, Avg, Max, Count,...) not working

stelei — Thu, 31 Mar 2022 09:45:07 GMT

Hello Everybody

I tried to create a PixelPerfect report with NPrinting and I can´t get the totals working. This is what I did so far.

And this is what I get:

In tutorials and other post in the forum I saw that the group-fields can be found in the level-hierarchy. But I don´t know how I add the desired fields there.

THX

Re: Nprinting Pixelperfect Total (Sum, Avg, Max, Count,...) not working

Frank_S — Thu, 31 Mar 2022 13:40:57 GMT

@stelei

Try the steps in this article

https://community.qlik.com/t5/Knowledge/How-to-Create-a-Pixel-Perfect-with-Nested-Totals-and-Subtotals/ta-p/1877746

Kind regards...

Re: Nprinting Pixelperfect Total (Sum, Avg, Max, Count,...) not working

stelei — Thu, 31 Mar 2022 14:19:55 GMT

Thanks for your help @Frank_S
But this is exactly what I tried before.

The difference between my report and the tutorial you provided is, that the fields show up under the levels.
Tutorial:

And my example is using a table from Qlik Sense and therefore the fields I try to summarize show up under Tables.
My Example:

THX

Re: Nprinting Pixelperfect Total (Sum, Avg, Max, Count,...) not working

Frank_S — Thu, 31 Mar 2022 14:43:40 GMT

@stelei

You should try this again using levels as shown in the article and not with tables.

Go carefully through each step.

In fact I would suggest using the sample QVF and PxP report I've provided in the article to help you work through your use case.

It should work as expected with levels.

Re: Nprinting Pixelperfect Total (Sum, Avg, Max, Count,...) not working

stelei — Thu, 31 Mar 2022 14:48:13 GMT

Now I got it.
I wasn´t aware that I can add a Qlik Sense Table as a Level in Nprinting. To be honest, that doesn´t really make any sense to me. ^^

But many thanks for your help. @Frank_S

Re: Nprinting Pixelperfect Total (Sum, Avg, Max, Count,...) not working

Frank_S — Thu, 31 Mar 2022 14:57:13 GMT

Perfect! @stelei

Happy to help...

Cheers!