Creating a simple PixelPerfect report

Create a new PixelPerfect report template

Do the following:

1. Select Reports in the Qlik NPrinting main menu, and then click Create report.
2. Enter a Title for the report. Simple PixelPerfect Report.
3. Select PixelPerfect from the Type drop-down list.
4. Select an app from the App drop-down list.

5. Select a Template from the options available:

   • Empty template - uses an empty template

   • Default template - use the default template (only available if a default template has been set in Report settings.

     See Load an Office, HTML or PixelPerfect file as a template

   • Custom - Choose a file to use as a template.
6. Click Create to create the report.
7. Click Edit template to open the Template Editor.
8. Right-click the Levels node, and select Add levels.

Insert a QlikView table as level

Do the following:

1. Select the Connection to the QlikView document that contains the object you want.

2. Enter 1 and 8 into the search field to reduce the number of candidate objects to five.

   If Top 25 Products - CH184 is the only object visible, press Enter to add it to the Levels node. Otherwise, select it in the list.

3. Click OK.

   CH184 will be added to the Levels node.

Create level details

Do the following:

1. Right-click on the Detail area in the middle of the page.
2. Select Insert Detail Report.
3. Choose CH184_Level from the list.

Create data columns

Do the following:

Set column order

To change the order of the columns, do the following:

1. Click in a cell to select it, for instance the first GP%.
2. Click on the small arrow that appears in the upper right corner to open the Table Cell Tasks menu.
3. Open the Data Binding drop-down list and expand the CH184_Level.GP% node.
4. Select Product Name to set this field as the first column.
5. Repeat 1 through 4 for the other columns in the order Total Sales, Gross Profit and GP%.

To eliminate inter-row white space, select the dotted line below the table and overlap it with the bottom line of the CH184_level table.

Create table headings

Do the following:

1. To add column headings, drag and drop the Table object from the Tool Box on the right.
2. Align the new table with the upper left corner of the Detail area.

Insert a fourth column

It is necessary to create a new column to match the data structure.

Do the following:

1. Right-click the third cell, select Insert, and then click Column to Left.
2. Select the right border of the fourth cell and drag it until the guideline overlaps with the right border of the fourth cell of the CH184_Level table.
3. Repeat this action with the other cells until they are aligned with the corresponding cells in the CH184_Level table.
4. Double-click the first column on the left to edit the text and enter Product Name.
5. Repeat the process with the second column and enter Total Sales.
6. Enter Gross Profit in the third cell and Gross Profit % in the last cell.
7. Select the entire table by clicking on the upper left corner.
8. Set the font type, dimension, alignment, and so on, as you prefer. For example, select Sans serif, 14px, Bold and Centered.
9. Select the row of table headings and then find Borders in the Property Grid in the lower left corner.
10. Select All in the drop-down list.
11. Click the drop-down button to accept the updated borders.
12. Select the bottom border of the Detail area and align it with the bottom border of the table to eliminate the empty space.

Set table data borders

Do the following:

1. Select the entire data table in the DetailReport - CH184_Level area.
2. Find Borders in the Property Grid.
3. Select All in the drop-down list. The Border icons become yellow.
4. Click the drop-down list to accept the updated borders.
5. Keep the data table selected.

6. Set the font format you prefer. For example, select Sans serif, 11px.

Set data alignment

Do the following:

1. Select the ProductName cell.
2. Find Text Alignment in the Property Grid.
3. Click the drop-down list, and then set text alignment to Middle Left.
4. Select the Total Sales cell.
5. Set text alignment to Middle Right in the Property Grid.
6. Repeat steps 5 and 6 for columns Gross Profit and Gross Profit %.

Format numbers

To set the number formatting to Dollar currency, do the following:

1. Select the Total Sales cell, and then click on the upper right arrow >.
2. Click on the dots on the right of Format String in the new window, and then select Currency.
3. Click on the Custom tab.
4. Select the $0.00 format.
5. Click OK.
6. Repeat steps 1 to 5 for the Gross Profit cell.
7. Format Gross Profit % as Percent 0.00%.

Preview and save

Do the following:

1. Click Preview.
2. Check the report, close it, and then edit the template again if necessary.
3. Click Save and Close to save the template and close the Template Editor.