Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

How to Create a Pixel Perfect with Nested Totals and Subtotals

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Frank_S
Support
Support

How to Create a Pixel Perfect with Nested Totals and Subtotals

Last Update:

Jan 5, 2022 6:57:08 PM

Updated By:

Frank_S

Created date:

Jan 5, 2022 6:25:15 PM

Attachments

 

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:

Embedded Levels with 'repeat every page' on group header 1.PNG

 

  • 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

Summarize Data Group and Report footer.PNG

 

Summarize Data Group and Report footer2.PNG

 

Save and Preview the report

  • The final page of this multi page report output appears as shown belowfinal page of output.PNG
 

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

 

Related Content

Labels (2)
Contributors
Version history
Last update:
‎2022-01-05 06:57 PM
Updated by: