Creating PixelPerfect reports with a level
You can create PixelPerfect reports with a level to repeat the content of a part of the report for each value of the field or table added to the Levels node.
You can add chart objects (images, tables, and charts) in the repeated report part. In this example, you will create a report that shows a page for each year with two different charts from QlikView.
You can use QlikView objects that have calculated dimensions or null values as levels. However, you cannot nest other objects inside them, except for fields from that sheet object. Qlik Sense visualizations with calculated dimensions cannot be used as levels.
Creating a new PixelPerfect report
Do the following:
- Select Reports in the Qlik NPrinting main menu, and then click Create report.
- Enter a Title for the report. PixelPerfect Report with Level.
- Select PixelPerfect from the Type drop-down list.
- Select an app from the App drop-down list.
- Click Create to create the report.
- Click Edit template to open the Template Editor.
- Right-click the Levels node, and select Add levels.
- If necessary, select the Connection to the QlikView document that contains the object you want. In this case, select Sales Demo.
- Enter Year - F\Year in the Search box, and then select Year from the objects list.
- Click OK.
- Right-click in the Detail area.
- Select Insert Detail Report.
- Click Year_Level.
- Expand the Year_Level node.
- Drag and drop the Year field under the Levels - Year_Level node into the DetailReport - Year_Level area.
-
Configure the text by using the Font menu in the ribbon bar.
For example, set it to Open Sans,16px, Bold, Centered.
- Center the [Year] cell between the left and right margins using either:
- the Location control under Layout in the Property Grid or;
- the Center Horizontally control in the Layout group of the toolbar.
Add two QlikView objects as images
Do the following:
- Right-click the Images node, and select Add objects.
- Select the Connection to the QlikView document that contains the object you want.
- Type the number 1 in the Search field and both Top 25 Products - CH184 and Top 10 Salesmen - CH192 are visible.
- Select Top 25 Products - CH184 and CH319 - Top 5 Salesman from the QlikView object list by holding down the Ctrl key.
- Click OK to add them to the Images node.
- Select the bottom dotted line of the DetailReport - Year_Level area, and then move it down to obtain a more ample workspace.
- Drag the CH184 node token into the template, and then drop it flush with the left margin.
- Open the drop-down list for the Sizing attribute under Behavior in the Property Grid, and then select Auto-Size.
- Drag CH192 from the Images node and drop it under CH184, flush with the left margin.
- Once again, select Auto-Size from the drop-down list.
- Drag the Page Break object from the Tool Box, which is typically docked on the right side of the Template Editor, and then drop it onto the bottom of the page.
Preview and save
Do the following:
- Click Preview.
- Check the report, close it, and then edit the template again if necessary.
- Click Save and Close to save the template and close the Template Editor.