How to Create a Pixel Perfect with Nested Totals and Subtotals

Frank_S — Wed, 05 Jan 2022 23:57:08 GMT

The following report was created with NP May 2021 SR 2. You can use import it and use it as a guide to create your own report but may not work fully if your version of NPrinting differs.

First

This example embeds 2 sub-levels off the 'Year' dimension level.
- Year>CategoryName>Top Sales Chart (see 'Field List' on upper left side of template editor in the image below)
Right click and 'Insert detailed reports' for each corresponding level
Manually type your column headers in 'Group Header 1' using the label box tool on the right side of the template editor. Use Text boxes to describe the data where needed.
Drag your data fields in as needed
- Notice the 'repeat every page' group header option to ensure column headers repeat on each page where tables expand over multiple sheets. This property is accessed via the yellow arrow box when clicking directly on the Group Header band. Shown below:

Create two group footers and one report footer exactly as shown above then drag in your data fields into the corresponding footers

Finally, Do the Summing

Click on the data cell you wish to format (this must be done one cell at a time)
Using the 'right arrow' properties tool for the data cell, you will need to select your format type using 'format' string and use 'summarize data' using 'group' option for group footers and 'report' option for the report footer

Save and Preview the report

The final page of this multi page report output appears as shown below

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

Attachments: Sample QVF, Exported Report and Report output

article How to Create a Pixel Perfect with Nested Totals and Subtotals in Official Support Articles

How to Create a Pixel Perfect with Nested Totals and Subtotals

Related Content