Creating PixelPerfect charts

You can create native PixelPerfect charts filled with QlikView or Qlik Sense data. In this example, the data source is a QlikView table. It is not necessary that the chart exist in the original .qvw file.

Create new 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. Top 10 Countries Sales.
3. Select PixelPerfect from the Type drop-down list.
4. Select an app from the App drop-down list.
5. Click Create to create the report.
6. Click Edit template to open the Template Editor.
7. Click the triangle in the corner between the two rulers.
8. Open the drop-down list of the Measure Units field.
9. Select Pixels from the menu.
10. To increase the area of the report reserved for the chart, click the bottom margin dotted line and drag it to the 550 pixel mark.
11. Read the height on the vertical ruler.

Add QlikView object

Do the following:

1. Right-click the Tables node, and select Add objects.
2. Select the Connection to the QlikView document that contains the object you want.
3. Enter 32 in the Select Tables search field.
4. Select the Top 10 Countries Sales in chart from the SalesDemo connection.
5. Click OK.

Embed new chart

Do the following:

1. Select the Chart object from the Tool box, and then drag and drop it into the Detail area.

   The chart wizard will open.

2. Leave the Bar type chart selected .
3. Click the Next button at the bottom of the wizard.
4. Click the Next button again to reach the Series window.
5. Select Series 2.

6. Click the Remove button at the bottom of the Series pane.

   Series 1 will be selected automatically.

7. Enter Sales as in the Series name field.
8. Click Next at the bottom of the wizard.
9. Select the Series Binding tab.
10. Open the Argument drop-down list in the Argument Properties area.
11. Expand the CH320 node, and then double-click the Country field to select it.
12. Open the Value drop-down list in the Value Properties area .
13. Double-click the Sales field.
14. Click Next.
15. Click Point Labels in the Presentation area at the left.
16. Remove the Visible flag.
17. Click Finish in the bottom right corner.
18. Drag the bottom right corner of the chart to fill all the available space.

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.