Solved: I have issue with Subtotals in NPrting - Qlik Community

abubakarsiddiq7 · ‎2022-09-08

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,

Ruggero_Piccoli · ‎2022-09-09

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

Ruggero_Piccoli · ‎2022-09-09

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.