Vizlib Finance Report Guides - NPrinting

NPrinting is a reporting add-on product for Qlik Sense used with the Vizlib Finance Report.

The Qlik Sense knowledge base has more NPrinting references, and a wide range of tutorials and demonstrations on the Qlik Sense YouTube channel, including a product tour for getting started with NPrinting.

This topic contains the following sections:

NPrinting Best Practice

To help you with setting up your NPrinting function within Vizlib Finance Report, we've included a list of guidelines and settings to follow, as well as any limitations there might be:

  • The preferred output formats are Excel (xls or xlsx) or HTML.

  • Set sheet size to 100% for the Vizlib Finance Report object.

  • Extending the sheet has no effect on the exported image size.

  • Currently, formatted Excel exports for Vizlib Finance Report are not supported in NPrinting.

Output Formats for Vizlib Finance Report

Output Format Description
HTML Report - Image

Maximum resolution is 1920x1080.

If the Finance Report object is larger than 1920x1080, NPrinting crops the image. Setting height and width on the img element has no effect.

Excel Report - Image

Maximum resolution is 1920x1080.

If the Finance Report object is larger than 1920x1080, NPrinting crops the image.

Using the Stretch property in Excel removes the cropping of the image, but may produce a pixellated result.

For the best result, use Max Height and Max Width properties for a larger area than 1920x1080 and customize it using Stretch to Fit.

Pixel Perfect Report

Not currently supported with Vizlib Finance Report.

Excel Report - Table

Requires NPrinting 2018 June or higher.

Exporting as Table uses the built-in exportData function in Qlik Sense, and exports the HyperCube to Excel.

This produces the same result as exporting a native Qlik Sense Pivot Table, but not the same result as Custom Formatted Excel export in Vizlib Finance Report.

Other Reports - Image

Maximum resolution is 1920x1080.

If the Finance Report object is larger than 1920x1080, NPrinting crops the image.