Excel reports
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
Tables
You can add QlikView and Qlik Sense table objects and apply
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 charts
You can use Qlik data to add a native
Excel pivot tables
You can create