topic Re: Getting Totals Row into nPrinting template in Qlik NPrinting

Getting Totals Row into nPrinting template

rittermd — Tue, 27 Dec 2016 15:15:23 GMT

I have a totals row in my QS table that I want to get into my nPrinting Word template.

However, when I add the table to the template this row is not there.

I have added a manual totals row to my Word table by adding a Formula row. But this is not adding correctly because of how I am formatting my data. If I wasn't doing this then this would have worked perfectly for me.

So the $60,000 question is can you bring the Totals row over from QS?

This is the latest build of nPrinting

Re: Getting Totals Row into nPrinting template

mkelemen — Tue, 27 Dec 2016 16:52:52 GMT

Hi,

I only have np 16 but there is a Show totals flag in the table properties. Is it not available in the latest version?

Unfortunately it puts the Expression total at the top of the exported table. The Dimension limits total is displayed correctly.

BR,

Matus

Re: Getting Totals Row into nPrinting template

rittermd — Tue, 27 Dec 2016 17:05:26 GMT

There is no option like that for the table in 17 that I see.

Re: Getting Totals Row into nPrinting template

mkelemen — Tue, 27 Dec 2016 17:55:08 GMT

It is not mentioned in the known limitations in the release notes so I assumed the functionality is there.

Did you try Dimension limit totals as well? I'm just curious but other than that I am out of ideas.

Re: Getting Totals Row into nPrinting template

rittermd — Tue, 27 Dec 2016 19:02:33 GMT

So if I limited the dimensions how would that help me display the totals row in nPrinting? I'm not clear on that.

Re: Getting Totals Row into nPrinting template

mkelemen — Tue, 27 Dec 2016 20:35:34 GMT

Sorry, it is only available in QV. You can have two different totals in table - one is enabled in Expressions and other in Dimension limits and they behave a bit differently. But in QS there is only one option.

Re: Getting Totals Row into nPrinting template

Anonymous — Wed, 28 Dec 2016 09:54:08 GMT

If there is no "show total" option like nprinitng 16 for QV, then I guess it is not available yet in nprinitng 17.2. The developer team are working hard to bring all the functions in 16 to 17.

In order to confirm, I have a quick check of the manual of 17.2 here, they introduce to use excel formula to get the total. So I think it is still not available.

Zhihong

Re: Getting Totals Row into nPrinting template

pierreh — Thu, 14 Apr 2022 16:39:58 GMT

Hi, is it still not available in latest versions ?

Re: Getting Totals Row into nPrinting template

Digvijay_Singh — Thu, 14 Apr 2022 16:54:17 GMT

didn't try yet but AFAIK It has been released in Feb 2022 Qlik Sense release and I guess it should be available now in nprinting as well(I guess in May 2021 onwards in), We are just one version behind and looking forward to this feature.

https://community.qlik.com/t5/Qlik-Product-Innovation-Blog/Qlik-Sense-February-2022-Client-Managed-release-is-now-available/ba-p/1890701