Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
abubakarsiddiq7
Contributor III
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 ?

abubakarsiddiq7_0-1662654014083.png

 

Thanks,

 

Labels (2)
1 Solution

Accepted Solutions
Ruggero_Piccoli
Support
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.

View solution in original post

1 Reply
Ruggero_Piccoli
Support
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.