Working with Qlik objects

Qlik Sense and QlikView have many different object types: bar charts, pivot tables, KPIs, maps, and more. How these objects can be used in Qlik NPrinting reports depends on the type of connection, and the type of object.

In order for Qlik objects to appear in your reports, you need to have a working connection to your Qlik Sense app or QlikView document. See: Creating connections .

How Qlik objects are exported into Qlik NPrinting

Properly connected Qlik objects are exported into Qlik NPrinting. They may not look exactly the same, or behave the same way. For example, bar charts export as static images. You cannot manipulate an image of a bar chart the same way as a bar chart.

These are the main ways Qlik objects can be displayed in Qlik NPrinting reports:

  • Text: simple text that can be formatted differently depending on report type. An Excel report will have different formatting options than a PixelPerfect report.
  • Tables: take your Qlik Sense and QlikView data and present it in tabular form.
  • Images: take your Qlik Sense and QlikView data and present it as a graphic (.png format).
  • Levels: sub-divide your data by a dimension. Levels can be applied to tables and images. For example, you could divide your top customers by region.

QlikView objects are exported using the native QlikView export sheet image function.

Qlik Sense objects are converted as follows:

  1. Opens the visualization in an in-memory browser window.
  2. Applies the dimensions and dots per inch (DPI) settings outlined in the report template.
  3. Takes a snapshot of the rendered image.
  4. Imports the image as .png.

Only the visible part of a visualization will be exported. For example, you export a Qlik Sense table that has scroll bars as an image. You will see the scroll bars and the window area that they specify, but not the entire table. To see how an object will appear in a report, open a Qlik Sense browser window on the Qlik NPrinting Engine machine. Next, apply the same size and resolution used in the report template.

You can adjust the amount of chart data taken in the initial snapshot in the Qlik NPrinting Designer by changing the Data Displayed values. See: Changing image size of Qlik Sense charts.

Note: You can export a visualization extension (custom object), if the visualization extension is set up to allow it, and the security rules for your installation of Qlik Sense allow it.

Qlik objects that are not fully supported

Some objects are not fully supported, because they are too complex.

A quick way to check if an object type is supported is to try and add it to the left-hand pane in Qlik NPrinting Designer. Qlik NPrinting Designer will only add supported objects.

For example: you are connected to a QlikView document that contains a bar chart, a pivot table, and a gauge chart. In Qlik NPrinting Designer, go to the left-hand pane, right-click on Levels, and select Add levels. A window will open, listing the bar chart. The pivot table and gauge chart will not be listed, as they are not supported as levels. They would appear if you added them under Images.

If a supported object does not appear in a list, it could be because it was added in Qlik Sense or QlikView, but the metadata cache was not refreshed in Qlik NPrinting. See: Reloading connection metadata.

The following tables outline current restrictions:

QlikView restrictions
Object Cannot be used as Can be used as
Pivot tables Levels, text Images, tables
Containers Levels, tables, text Images
Object filters Levels, text Images, tables
Gauge charts Levels, text Images, tables
Qlik Sense restrictions
Object Cannot be used as Can be used as
Gauge charts Levels, text Images, tables
KPIs Levels, text Images, tables
Text and images Levels, text Images, tables
Maps Levels, tables, text Images
Pivot tables Levels, other restrictions Tables, text, images
Filter panes Levels, tables, text Images
Sense extensions Text Images, tables, levels

Qlik Sense pivot table restrictions

Qlik Sense pivot tables are supported as images, text, and tables. However, there are some features and behaviors that are not supported:

  • Levels
  • Partial expansion of rows and columns
  • Foreground colors and background colors
  • Hyperlinks (will display as plain text)
  • Expanding or shrinking the size of the table. The desired pivot table size must be saved in the Qlik Sense app, before you open the report in Qlik NPrinting Designer. If you change the size or layout of the table in Qlik Sense, you will need to reload your Qlik Sense connection cache in Qlik NPrinting.

Qlik objects that are not supported

Some Qlik objects are not supported in Qlik NPrinting. These are:

  • Uncertified Qlik Sense extensions
  • Qlik Sense objects that connect to external servers, usually as additional data sources (Qlik GeoAnalytics, analytic connections)
  • Qlik Sense charts with Assistance enabled. To include charts created using chart suggestions in Qlik NPrinting reports, disable Assistance. See: Creating visualizations using chart suggestions.

Note:

Tables that have calculated dimensions or null values can be used as levels, but you cannot put any objects or levels inside them.

Troubleshooting

If your objects are not appearing in your reports correctly, there could be an issue with your connections, or with your Qlik Sense app or QlikView document.

See also:

 

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?