Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP

How to Create PixelPerfect Charts

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

How to Create PixelPerfect Charts

Last Update:

Nov 20, 2015 12:07:17 PM

Updated By:

Frank_S

Created date:

Nov 20, 2015 12:07:17 PM

Description: Learn how to create PixelPerfect Charts filled with QlikView data.

Create New Template

Create-New-Template.png

Launch NPrinting and open the C:\NPrintingTraining\NPrintingFiles\NPrintingTraining.nsq file

  1. Go to Reports
  2. Select PixelPerfect reports
  3. Click on the PixelPerfect Report button to create a new one
  4. Change the name to Top 10 Countries Sales
  5. Click on New to create a new template. The template editor will open.

Set Grid Scale Units

Set-Grid-Scale-Units.png
  1. Click on the triangle in the corner between the two rulers
  2. Open the drop-down menu of the Measure Units field
  3. Select Pixels from the menu

Increase Chart Area

Increase-Chart-Area.png


Click on the bottom margin dotted line and drag it to the 550 pixel mark to increase the area of the report reserved for the chart. Read the height on the vertical ruler.

Add QlikView Object

Add-QlikView-Object.png
  1. Right click on the Tables node
  2. Select Add objects

Select Table Object

Select-Table-Object.png
  1. Select the Connection to the QlikView document that contains the table you want
  2. Enter '3' and '2' in the Select Tables Search field
  3. Select the Top 10 Countries Sales in chart from the SalesDemo connection
  4. Click on the OK button

Embed New Chart

Embed-New-Chart.png


From the Toolbox on the right side select the Chart object then drag and drop it into the Detail area. The Chart wizard will open.

Select the Chart Type

Select-the-Chart-Type.png
  1. Leave the Bar type chart selected
  2. Click on Next button at the bottom of the wizard
  3. Click on Next again to reach the Series window

Delete Useless Data Sources

Delete-Useless-Data-Sources.png
  1. Select Series 2
  2. Click on the Remove button at the bottom of the Series pane

Rename Series 1

Rename-Series-1.png
  1. Series 1 will be selected automatically
  2. Enter Sales as the new Name for Series 1
  3. Click on Next at the bottom of the wizard

Configure Argument

Configure-Argument.png
  1. Select the Series Binding tab
  2. Open the Argument drop-down menu in the Argument Properties area
  3. Expand the node CH320 and double click on the Country field to select it

Configure Values

Configure-Values.png
  1. Open the Value drop-down menu in the Value Properties area
  2. Double click on the Sales field
  3. Click on Next

Hide Point Labels

Hide-Point-Labels.png
  1. Click on Point Labels in the Presentation area at the left
  2. Remove the Visible flag
  3. Click on Finish in the bottom right corner

Set Chart Dimensions

Set-Chart-Dimensions.png


Drag the bottom right corner of the chart to fill all the available space.

Save the Template

Save-the-Template.png

  1. Click on the Save As icon in the Report group of the tool bar
  2. Make sure that the Save As window is set to save in the C:\NPrintingTraining\Templates\ folder
  3. Confirm the File Uame, Top 10 Countries Sales.npx
  4. Click on the Save button

Preview Report

Preview-Report.png

Click on the Preview icon in the Report group to check the final result.

Version history
Last update:
‎2015-11-20 12:07 PM
Updated by: