Skip to main content

Excel reports

Excel reports let you export QlikView and Qlik Sense charts to Excel workbooks. You can easily make new calculations or add pivot tables.

Excel reports can be generated and shared in the following output formats: xlsx, .xls, .xlsm, .tiff, .pdf, .html.

Note: Excel macros (in .xls and .xlsm files) will not run in Qlik NPrinting Designer if your Microsoft Office trust settings disable macros. This is the default setting in Excel. You can change this in Excel by going to Options > Trust Center > Trust Center Settings > Macro Settings.

Formatting

As the default, Qlik NPrinting attempts to keep the original QlikView or Qlik Sense formatting when you create a new report template. Alternatively, you can apply Excel formatting. Select the chart object in the Qlik NPrinting Designer and clearing the Keep Source Formats check box in the Properties pane. Then you can customize fonts, column width, and table properties like in any Excel document.

Tables

You can add QlikView and Qlik Sense table objects and apply Excel table functions. For example, you can apply Excel table formatting. You can use entire QlikView or Qlik Sense tables or select specific columns.

Font and alignment formatting applied from the Excel ribbon to the heading cell will be applied to all table cells in the heading row. Font and alignment formatting applied from the ribbon to a content cell will be applied to all table cells in content rows. Number formatting will have no effect.

Images

You can import charts as images. The original image formatting is kept, as the default setting. For example, if the original QlikView object has a side scroll bar, you will see it in the report. You can also import entire QlikView sheets as images. Data included in objects that are imported as images cannot be edited in the final report.

Images can be embedded side-by-side. You must manually adjust the space between them to avoid overlap. Qlik NPrinting does not automatically add space or columns between images.

Levels

Levels take chart objects and cycle them through the values of a field. The results for each level field value are displayed in order. You can add levels to images, tables, and fields.

For example, you have a Qlik Sense app with a table listing each product you have sold in a year. You can add that table to a Qlik NPrinting report, and add a level for the Product Category field. Your generated report will have a different table for each Product Category, instead of one large table.

Formulas

You can use the Formulas node to add QlikView and Qlik Sense formulas. You can input Excel formulas directly in template cells.

Excel charts

You can use Qlik data to add a native Excel chart to your reports.

Excel pivot tables

You can create Excel pivot tables from QlikView or Qlik Sense straight tables.