Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

rittermd
Honored Contributor

Getting Totals Row into nPrinting template

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

6 Replies
mkelemen
Contributor III

Re: Getting Totals Row into nPrinting template

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

rittermd
Honored Contributor

Re: Getting Totals Row into nPrinting template

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

mkelemen
Contributor III

Re: Getting Totals Row into nPrinting template

​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.

rittermd
Honored Contributor

Re: Getting Totals Row into nPrinting template

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

mkelemen
Contributor III

Re: Getting Totals Row into nPrinting template

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.

geminihzh
Valued Contributor

Re: Getting Totals Row into nPrinting template

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

Community Browser