Native Table - Total issue in NPrinting PPT

MMK — Wed, 16 Aug 2023 15:11:43 GMT

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.

Re: Native Table - Total issue in NPrinting PPT

Lech_Miszkiewicz — Thu, 17 Aug 2023 00:34:22 GMT

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/m-p/1825352

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

topic Native Table - Total issue in NPrinting PPT in Qlik NPrinting

Native Table - Total issue in NPrinting PPT

Re: Native Table - Total issue in NPrinting PPT