Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for
Did you mean:
Contributor III

## I have issue with Subtotals in NPrting

Hi Experts,

I am facing  issue on Subtotals in NPriting

In NPrinting, I've created three different levels (dimensions): Area, Region, and Agency, and I'm attempting to get subtotals, but I'm getting subtotals only for Region and Agency, but I'm getting incorrect values for Area. Can anyone help me here ?

Thanks,

Labels (2)

• ### Subtotals

1 Solution

Accepted Solutions
Support

Hi,

Please post Qlik NPrinting questions on its community at https://community.qlik.com/t5/Qlik-NPrinting-Discussions/bd-p/qlik-nprinting-discussions

When you create totals of nested levels using Excel formulas you have to remember to divide because in puter level formulas you are summing the details and their totals. Refer to https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/ExcelReports/Excel-Reports-Nesteds.h.... So in the inner level you can simply use =sum(range), in the second level you have to use =sum(range)/2 because it includes the details and the totals of the previous level, and so on.

Best Regards,

Ruggero

Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
Support

Hi,

Please post Qlik NPrinting questions on its community at https://community.qlik.com/t5/Qlik-NPrinting-Discussions/bd-p/qlik-nprinting-discussions

When you create totals of nested levels using Excel formulas you have to remember to divide because in puter level formulas you are summing the details and their totals. Refer to https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/ExcelReports/Excel-Reports-Nesteds.h.... So in the inner level you can simply use =sum(range), in the second level you have to use =sum(range)/2 because it includes the details and the totals of the previous level, and so on.

Best Regards,

Ruggero

Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
Community Browser