Qlik Community

Qlik NPrinting Documents

Documents related to Qlik NPrinting.

How to Create a Well Formatted PixelPerfect Chart

Support
Support

How to Create a Well Formatted PixelPerfect Chart

Description: Learn how to create a PixelPerfect Chart based on QlikView data. The new chart imports data from a QlikView document but does not exist in QlikView. The  chart is created in the report. Learn also how to set advanced graphic attributes.

If you haven't recently done so, download the latest version of Vizubi NPrinting Training environment available via the NPrinting Training Material Page. See the following link for download instructions: NPrinting Training Material

Create New Report and Template

Create-New-Report-and-Template.png

  1. Enter PixelPerfect Bar Chart as the report Name
  2. Click on the New icon in the Template group of the tool bar

Set Template Scale to Pixels

Set-Template-Scale-to-Pixels.png
  1. Click on the triangle at the corner between the two rulers
  2. Go to the Measure Units menu item
  3. Open the drop-down menu by clicking on the down pointing triangle at the extreme right of the field
  4. Select Pixels

Configure Workspace Format

Configure-Workspace-Format.png
  1. Go to the Property Grid, which is usually docked at the lower left of the work area but can be enlarged and floated to any convenient position in the workspace or even docked on another side
  2. Go down to the Page Settings group of attribute controls
  3. Change the Paper Kind to the size that you normally use
  4. Set Margins as appropriate (the Margins node has been expanded here so that you can see the unconventional order)

Make Room in Template Workspace

Make-Room-in-Template-Workspace.png


Drag the bottom border of the template down to the 350 pixel mark.

Add Object to Template as Table

Add-Object-to-Template-as-Table.png

Add CH311 to the Tables node.

Embed Chart Object

Embed-Chart-Object.png

Drag the Chart object from the Tool Box into the template and drop it into the upper left corner of the Detail range aligned with the left margin and the bottom border of the Detail bar. The Chart Wizard opens automatically to the Chart Type page.

Select Chart Type

Select-Chart-Type.png


Select Bar for the Chart Type and click on the Next >> button at the bottom of the window. This moves you to theAppearance page.

Select Color Palette

Select-Color-Palette.png
  1. Open the Palette drop-down menu
  2. Select the color palette that looks best. The Origin palette has been chosen here.
  3. Click on the Next >> button at the bottom of the window

Create and Configure Series

Create-and-Configure-Series.png
  1. Select Series 2
  2. Click on the Remove button at the bottom of the Series pane
This creates a simple chart displaying only one series.

Configure Series 1

Configure-Series-1.png
  1. Enter Sales for the Series name
  2. Set Point sort order to Ascending
  3. Set Sort points by to Value
Setting Sort points by to Argument would list points by category names in alphabetical order

Configure Legend Points

Configure-Legend-Points.png
  1. Select the Legend Point Options tab
  2. Deselect Synchronize with point options
  3. Open the Point view drop-down menu
  4. Select Argument and Values
  5. Set Value format to Currency
  6. Set Value precision to 0, this sets the number of significant digits to the right of the decimal point to none
  7. Click on the Next >> button at the bottom of the window

Bind Argument

Bind-Argument.png
  1. Select the Series Binding tab
  2. Open the Argument drop-down menu in the Argument Properties box
  3. Expand the CH311 node
  4. Select CategoryName node

Bind Value

Bind-Value.png
  1. Open the Value field drop-down menu under Value Properties
  2. Select the Sales node under the CH311 node
  3. Click on the Next >> button at the bottom of the window

Explore Chart Page

Explore-Chart-Page.png

The Chart page provides controls for appearance attributes such as background color, padding (internal distance of content from margins), text in empty and small charts. Explore various values, but the predefined settings are used for this tutorial. Click on the Next >> button.

Change Diagram Orientation

Change-Diagram-Orientation.png

Configure secondary axes, margins, and other diagram attributes on the Diagram page.
  1. Put a check mark in the Rotated box so that the bars will be displayed horizontally
  2. Click on the Next >> button

Inspect Panes Page

Inspect-Panes-Page.png


Have a look at the Panes page but leave the default settings. Click on the Next >> button.

Label X Axis

Label-X-Axis.png
  1. Select the Elements tab on the right
  2. Put a check mark in the Visible box. Antialiasing will also be activated automatically
  3. Enter Category in the Text field, it appears on the vertical axis because the diagram has been rotated

Label Y Axis

Label-Y-Axis.png
  1. Change from Primary AxisX to Primary AxisY in the drop-down menu at the top
  2. Make sure the Elements tab on the right is still selected
  3. Put a check mark in the Visible box. Antialiasing will also be activated automatically
  4. Enter Sales in the Text field, it appears on the horizontal axis because the diagram has been rotated

Format Label Content

Format-Label-Content.png
  1. Select the Labels tab on the right
  2. Select the Auto tab
  3. Set Format to Currency
  4. Set Precision to 0
  5. Click on the Next >> button

Set Bar Color

Set-Bar-Color.png
The Series View page let you to customize some visualization options
  1. Select the Appearance tab on the right
  2. Select pure, saturated blue (0; 0; 255) from the Color drop-down menu
  3. Click on the Next >> button

Antialias Point Labels

Antialias-Point-Labels.png

Customize point display on the Point Labels page.Put a check mark in the Antialiasing box under Text Settings on the General tab

Configure Point Label Content

Configure-Point-Label-Content.png
  1. Select the Point Options tab
  2. Leave Point view set to Values
  3. Select Currency for Value format
  4. Set Value precision to 0
  5. Click on the Next >> button

Add Chart

Add-Chart.png
Configure the chart heading on the Chart Titles page
  1. Click on the Add button to create a new title
  2. Enter Sales by Category as the heading
  3. Click on the Next >> button

Render Legend Invisible

Render-Legend-Invisible.png

Configure a chart legend on the Legend page. Set whether or not a legend is displayed and how. A legend is unnecessary for this simple chart so make sure that there is no check mark in the Visible box.Click on the Next >> button.

Add No Annotations

Add-No-Annotations.png

No Annotations are to be added. Click on the Finish button to close the Chart Wizard.

Adjust Chart Size

Adjust-Chart-Size.png

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

Open Save As Window

Open-Save-As-Window.png

Click on the Save As icon in the Report group of the tool bar.

Save Template

Save-Template.png
  1. Make sure the Save As window is open in the C:\NPrintingTraining\Templates folder
  2. Enter an appropriate File name or accept the suggested one: PixelPerfect Bar Chart.npx
  3. Click on the Save button

Run Preview

Run-Preview.png

Click on the upper part of the Preview button.

Inspect Report

Inspect-Report.png

Version history
Revision #:
1 of 1
Last update:
‎11-20-2015 12:12 PM
Updated by: