topic Re: Nprinting Excel Pivot Totals in Qlik NPrinting

Nprinting Excel Pivot Totals

Anonymous — Thu, 06 Sep 2018 12:41:37 GMT

Hi,

I have this table in my model:

Product | SaleAmount | CancelAmount | Reason
123       | 200                | 10                     | Defect
123       | 200                | 12                     | CustReturn
-------------------------------------
Totals:    | 200                | 22

But when i'm trying to create in Nprinting Excel Pivot table,

the totals is 400, because the excel can't figure out that it is the Product amount.

Is there a solution for this matter?

Thanks.

Re: Nprinting Excel Pivot Totals

Lech_Miszkiewicz — Fri, 07 Sep 2018 03:40:51 GMT

Hi Roman,

you are asking very specific question without giving us very specific information.

The simplest answer to your question is put the sale amount as a dimension or use MAX instead of SUM. It all depends on how you build your qlik app and how you build your template.

with provided information I can't help you more.

cheers

Lech

Re: Nprinting Excel Pivot Totals

Ruggero_Piccoli — Mon, 10 Sep 2018 14:53:29 GMT

Hi,

You can use all Excel pivot table features. So first you must be able to get what you want by using them without Qlik NPrinting (for example by using MAX as suggested by Lech) and after you use the same features in the template.

An alternative is to change the original object.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.