Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

gbarrett
New Contributor III

NPrinting Excel Report Dimension Subtotals

I need to create an Excel report in NPrinting 17 that consists of three dimensions (Product Category, Product Type, and Product Description) and a group of measures, but for this example I am using one measure for simplicity. What I would like to do is have a subtotal row after each Product Type, a subtotal row after each Product Category, and then a grand total row at the end of the table. I am not too worried about the Grand Total row because I can create a second table with just the totals below the main table. I am trying to figure out how to handle the subtotal rows, however. Essentially, I am trying to recreate the rollup totals in a Qlik Sense pivot table. As of now, I am bringing in the report as one table object with no levels. Can anyone offer any advice? Thanks.

Product CategoryProduct TypeProduct DescriptionSum of Sales
Cat 1Type AProduct 13
Cat 1Type AProduct 24
Cat 1Type AProduct 35
Subtotal Type A12
Cat 1Type BProduct 15
Cat 1Type BProduct 26
Cat 1Type BProduct 37
Subtotal Type B18
Subtotal Cat 130
Grand Total
1 Solution

Accepted Solutions
Employee
Employee

Re: NPrinting Excel Report Dimension Subtotals

Hi George,

Take a look at How to Create Excel Reports with Nested Levels and Subtotals

HTH - Daniel.

4 Replies
Employee
Employee

Re: NPrinting Excel Report Dimension Subtotals

Hi George,

Take a look at How to Create Excel Reports with Nested Levels and Subtotals

HTH - Daniel.

gbarrett
New Contributor III

Re: NPrinting Excel Report Dimension Subtotals

Thanks Daniel. Worked exactly as I wanted it to.

murali69
Contributor II

Re: NPrinting Excel Report Dimension Subtotals

Hi,

How to maintain only one Main column names for all nested levels.

Please help me with this?

NT.JPG

Employee
Employee

Re: NPrinting Excel Report Dimension Subtotals

Hi,

This is a new and different question so, please, open a new community conversation.

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.

Community Browser