Skip to main content

Member Articles

This forum is for user/member-created articles across the entire Qlik portfolio. Any member that is logged in can create and publish an article here. You must choose the appropriate label in order for the articles to be properly categorized.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!

How to Add Totals and Subtotals to PixelPerfect Reports

cancel
Showing results for 
Search instead for 
Did you mean: 
Ruggero_Piccoli
Support
Support

How to Add Totals and Subtotals to PixelPerfect Reports

In this tutorial you'll learn how to add totals and subtotals to QlikView Nprinting PixelPerfect reports using nested Levels. A hierarchy of levels can be created as deep as you need. Please, pay close attention to how nested levels are created here because the method is quite different from that used for other kinds of QlikView NPrinting reports.

Preliminaries:

  • See the tutorial How to Create a Simple PixelPerfect Report to learn the basics.
  • Download our NPrinting Training Material and extract it to C:\NPrintingTraining\ so that all relative paths remain valid.

Begin Creating New PixelPerfect Report

010.png

Open the NPrinting Project NPrintingTraining.nsq found in the C:\NPrintingTraining\NPrintingFiles\ folder.

  1. Select Reports in the lower left pane
  2. Select PixelPerfect reports
  3. Click on the PixelPerfect Report icon to create a new report

Name Report and Open New Template in Template Editor

020.png

  1. Enter PixelPerfect Report with Totals and SubTotals on Levels as the report Name
  2. Click on New in the Template group of the tool bar to create a new template

Add Levels to Template

030.png

  1. Right click on the Levels node
  2. Click on Add levels in the pop-up menu

Select Object for Level

040.png

  1. Select the Connection to the QlikView document that contains the object you want
  2. Select the CategoryName field
  3. Click on the OK button

Begin Nesting Levels

050.png

  1. Right click on the CategoryName_Level node
  2. Click on Add levels in the pop-up menu

Select Object for Sublevel

060.png

  1. Select the Connection to the QlikView document that contains the object you want
  2. Select the Top 25 Products chart
  3. Click on the OK button

Begin Creating Levels in Template

070.png

  1. Right click on the Detail bar or within its range
  2. Select Insert Detail Report
  3. Select “CategoryName_Level”

Embed Field in Detail1 Band

080.png

Drag the CategoryName node token from the Levels hierarchy and drop it into the Detail1 open template area.

Format Category Heading

090.png

  1. Drag the label left and right borders to cover the entire width of the range from margin to margin
  2. Set the font to Arial, 16pt, Bold, centered or format it as is appropriate for a category heading

Create the CH184 Sublevel

100.png

  1. Right click on the DetailReport - “CategoryName_Level” bar
  2. Select Insert Detail Report
  3. Select “CH184_Level”. The result is DetailReport1 - “CategoryName_Level.CH184_Level” bar.

Add Group Header

110.png
120.png

Embed Headings in Template

130.png

Format Heading Text

140.png

Format Heading Borders

150.png

Embed Data in Template

160.png

Format Data in Template

170.png

Render Borders Visible and Eliminate White Space

180.png

Open Table Cell Tasks and FormatString Editor

190.png

Format "CH184_Level.Total Sales" Cell

200.png

Format "CH184_Level.Gross Profit" Cell

210.png

Format "CH184_Level.GP%" Cell

220.png

Start Creating Subtotals

230.png

Adapt Cells

240.png

Open Summary Editor for CH184_Level.Total Sales Cell

250.png

Set Summary Running and Open Format String Editor

260.png

Format Cell Content and Close

270.png

Close Summary Editor

280.png

Repeat Process for CH184_Level.Gross Profit Cell

290.png

Format Subtotal Cell Content

300.png

Render Subtotal Cell Borders Visible and Eliminate White Space

310.png

Begin Creating Report Totals

320.png

Copy Subtotal Cells

330.png

Paste Subtotal Cells in ReportFooter

340.png

Open Summary Editor

350.png

Set Summary Running and Open FormatString Editor

360.png

Format Cell Data Content

370.png

Close Summary Editor

380.png

Format Report Total Cell Contents

390.png
 
Format the text as Arial, 14px, Bold, Right justified.

400.png
 
  1. Select the Borders option in Property Grid, which is the lower left pane
  2. Open the drop-down menu by clicking on the down-pointing triangle at the extreme right of the field
  3. Click on All to render all cell borders visible
  4. Drag the Report Total cell upper border till it coincides with the lower border of the ReportFooter bar lower border to eliminate the white space between the Category Subtotals and the Report Totals in the final report
 
410.png

Save Template

420.png

Name and Save to Specific Folder

430.png

Preview Report

440.png

Inspect Report Detail

450.png
Labels (1)
Version history
Last update:
‎2019-11-11 09:28 AM
Updated by:
Contributors