Native Table - Total issue in NPrinting PPT

[MMK]

Hi All,

Thanks in Advance for you support.

I am using Qlik Sense May 2022 Patch 9 and Nprinting Designer of version May 2022.

I want  a straight table from Qlik Sense app into PPT  Report.

The total part is missing in the Nprinting PPT report.

Any can help me how to show total also in PPT Report.

[Lech_Miszkiewicz]

Hi @MMK 

There is no out of the box solution in NPrinting for this and PPT Tables are quite funky to work with. The solution I am using which will work and will give you ability to put TOTAL on Top or Bottom of your table is by using grouping dimension which follows the same principles as I explained in this topic: https://community.qlik.com/t5/Qlik-NPrinting/Want-to-calculate-column-total-in-Nprinting-HTML-report...

In short - you need to create another EMP column which will have all values from EMP column and also TOTAL for all values from EMP column. Then you use that new column to build your table for NPrinting purpose (you may need to build dedicated object just form NPrinting).

cheers