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.
