Qlik Community

Knowledge

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
CASE PORTAL: Inability to view all organizations' cases. We are investigating. Thank you for being so patient.

How To Create a Pixel Perfect Report with Repeating Headers and One Dimension Value Per Page

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

How To Create a Pixel Perfect Report with Repeating Headers and One Dimension Value Per Page

First

  • Embed chart inside dimension to cycle through
  • Insert your data fields inside the detail band between the group header and footer
  • Use a group header (inserted directly above the detailed report band) and group foot footer (directly below the detailed report band).

Embed chart inside dimension to cycle through.PNG

 

Then:

  • Open the properties (yellow arrow) on the group footer band and select 'Page Break: after the band' This will produce one dimension value per page.

pxp footer.PNG

 

Now keep in mind

  • Your data might be too long for a single page. So in that case you will want the column headers to be inserted to the overflow page.

To do this you need to:

  • Click on the group header band, click on and open the properties arrow, then select 'repeat every page'.
  • Make sure to manually insert Text Labels into the group header field. (Trick: right click and hold on your chart dimension values, then drag to the template. This will create a text field with your column header name).
  • Insert your dimension tag (ie: category name) in the 'detail' band above the header band.

pxp header.PNG

 

This will work for both Qlik Sense and QlikView applications.

Tip: make sure to give your Qlik Charts friendly names so you can easily recognize them when adding them as levels.

Related Content

 

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.

Version history
Last update:
2 weeks ago
Updated by:
Contributors