Excel reports

Qlik NPrinting supports exporting QlikView and Qlik Sense data to Excel workbooks. Excel workbooks are updated instantly when a report is generated. Data is filtered according to recipient, report, and task. Only filtered data is saved in generated reports.

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.

Advanced Excel reports

You can embed QlikView and Qlik Sense objects in sheets and use the preview function to simplify editing. You can insert objects as tables or images, create multi-level reports, nest levels, show totals and subtotals, and more.

Excel charts

Use data to add a native Excel chart to your reports, even if the chart does not exist in the original document.

Calculated columns

Create a new column that was not present in your original document. The new column can calculate the values of other columns using formulas. Calculated columns are created by using levels or an Excel table.

Excel pivot tables

Present your data in an Excel pivot table that the recipient can interact with. The QlikView or Qlik Sense data source must be a straight table. Data from a pivot table needs to be converted to a straight table.

Excel formats

Use Excel formatting tools to design your reports. When creating templates for generating reports, you can present information with the same formatting as in your original document. By default, Qlik NPrinting attempts to preserve the original formats of imported objects. Excel formatting is also available.

Import cell values from objects

Import one or more cell values from QlikView or Qlik Sense objects into your Excel reports. This feature is also supported in Word, PowerPoint, HTML, and PixelPerfect reports.

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?