How to Create PixelPerfect Charts

    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.