Creating a well-formatted PixelPerfect chart

You can create PixelPerfect charts based on QlikView or Qlik Sense data. You can also create a PixelPerfect chart if the chart does not exist in the source document. In this example, QlikView objects are used to show how to work with advanced graphic attributes.

Create a new PixelPerfect report

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. Open the Report Tasks window by clicking on the triangle at the corner between the two rulers.
  8. In the Measure Units drop-down list, select Pixels.

Configure workspace format

Do the following:

  1. Go to the Property Grid, which is typically docked at the lower left of the work area.
  2. Navigate 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.
  5. Click the bottom margin dotted line and drag it to the 350 pixel mark.

Add object to template as table

Data sources for PixelPerfect charts are QlikView tables added to the tables node of the template editor.

Do the following:

  1. Right-click the Tables node, and then select Add objects.
  2. Select CH186 from the objects list.

  3. Click OK.

Embed chart object

Do the following:

  1. 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 to the Chart Type page.

  2. Select Bar for the Chart Type, and then click Next >> at the bottom of the window.

    The Appearance window appears.

  3. Open the Palette drop-down list, and then select a color palette.

    To create your own palette, select Edit palettes

  4. Click Next to open the Series window.

     

Create and configure series

Do the following:

  1. In the Series window, select Series 2.
  2. Click Remove at the bottom of the Series pane.
  3. Enter Sales for the Series name for Series 1.
  4. Click the Series Options tab.
  5. Set Point sort order to Ascending.
  6. Set Sort points by to Value.

    You can also list points by category names in alphabetical order by setting Sort points by to Argument.

  7. This creates a simple chart displaying one series sorted by value of sales in ascending order.

Configure legend points

You can customize the formats of the legends.

Do the following:

  1. Click the Legend Point Options tab.
  2. Deselect Synchronize with point options.
  3. Open the Point view drop-down list, and then select Argument and Values.
  4. Set Value format to Currency.
  5. Set Value precision to 0.

    This sets the number of significant digits to the right of the decimal point to none.

  6. Click Next to open the Data window appears.

Bind argument and value

Do the following:

  1. In the Dataa window, click the Series Binding tab.
  2. Open the Argument drop-down list in the Argument Properties box.
  3. Expand the CH186 node.
  4. Double-click the CategoryName node.
  5. Open the Value field drop-down list under Value Properties.
  6. Double-click the Sales node under the CH186 node.
  7. Click Next to open the Chart window.

  8. Click Next again to accept the default Chart settings, and to open the Diagram window.

Inspect pages

Do the following:

  1. The Diagram window allows you to set options related to the diagram. For example, rotate the diagram by checking Rotate.

  2. Click Next to accept the default Diagram settings, and to open the Panes window.

  3. Click Next to accept the default Panes settings, and to open the Axes window.

Label X axis

Do the following:

  1. In the Axes window, click the Elements tab.
  2. Select the Visible check 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

Do the following:

  1. Change from Primary AxisX to Primary AxisY in the drop-down list at the top.
  2. Make sure the Elements tab on the right is still selected.
  3. Select the Visible check 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

Do the following:

  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 Next >>

    The Series Views window opens.

Set bar color

The Series Views window lets you customize some visualization options.

Do the following:

  1. Click the Appearance tab.
  2. Select pure, saturated blue (0, 0, 255) from the Color drop-down list.
  3. Click Next to open the Point Labels window.

Antialias point labels

The Point Labels window lets you customize the labels of points in a chart.

Do the following:

  1. In the Point Labels window, customize point display.
  2. Put a check mark in the Antialiasing box under Text Settings on the General tab.

Configure point label content

Do the following:

  1. Click 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 Next to open the Chart Titles window.

Add chart title

Do the following:

  1. In the Chart Titles window, click Add to create a new title.
  2. Enter Sales by Category as the heading.
  3. Click Next to open the Legend window.

Configure chart legend

Do the following:

  1. Configure a chart legend in the Legend window. You can set whether or not a legend is displayed, and how the legend is displayed. A legend is not necessary for a simple chart, so ensure that there is no check mark in the Visible box.

  2. Click the Next button to open the Annotations window. No annotations are added.
  3. Click Finish button to close the chart wizard.
  4. 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.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?