What is NPrinting and why it is used?
Historically, QlikView has not had a particularly strong ability to print or publish reports. Qlik has preferred to concentrate their efforts on the strengths of QlikView – business intelligence and data discovery. This has lead to other companies producing their own add-ons to improve QlikView ability to distribute reports. NPrinting is one of these.
NPrinting is a 3rd party tool by Vizubi that connects to one or more QlikView and QlikSense files to quickly create reports that can be built from scratch or from existing templates.
NPrinting enables you to schedule and automatically distribute reports to multiple users via email, google drive or to a folder. These reports can be in excel, word, PowerPoint, html, pixel perfect, pdf etc.
How simple is distributing reports in NPrinting? Well, if you know QlikView, QlikSense and MS Office – simple!
How simple it is to receive and read NPrinting reports? Even simpler – just open your email and there they are, in pdf or a variety of MS Office document formats!
How to Use NPrinting 17 for QlikSense?
Here, we’re using a demo “Finance Sales and Operational Planning” application available from QlikSense. To Use NPrinting we must have QlikSense Server.
1. Log into Qlik NPrinting 17 web console at the following url: https://localhost:4993/#/dashboard
2. Enter the UserId and Password created when NPrinting Server was installed.
3. Click on Apps from the Apps drop-down menu.
4. Then Click the Create app button.
5. Give the App a Name and Description and click Create. It is now possible to create a connection to a QlikSense Application. Before that, we Must Import the “Finance Sales and Operational Planning” QlikSense Application into QMC to create the Connection.
6. Then we will get the created app on the Apps list like below window.
7. Click on Connections from the Apps drop-down menu. Then click on Create Connection Button.
8. Give the connection a Name and Description. In the app field, choose the Qlik NPrinting app with which to associate the connection from the drop-down menu. Click the Qlik Sense button as the source.
Tip: The QlikSense app ID is located in the QlikSense QMC under the Apps section. In case ID column is not in the app list, add the ID by the “Column Selector” in the QMC. The identity is the Domain Name along with the User Name.
9. Click the Create button in the lower right-hand corner. Here we need to reload the Meta data then click on “Reload metadata” at the corresponding application.
10. Then we will get Connection Status as ‘Ok’ and Cache Status as ‘Generated’. Once the cache has been generated, reports can be authored. Cache generation may take several minutes and will depend on the size of the app and the number of objects in the app.
11. Click on Reports Menu and then click the Create report button.
12. Give the Title a name and description. Choose the format type and the Qlik NPrinting app with which the report will be associated from the drop-down. Then select Template from empty file or custom file. Then click the Create button in the lower right-hand corner. In order to pre-load a default template to include things like logos and design put all in the Excel and upload the default template by selecting custom file.
13. Once the report is created, click on the Edit template button to launch Qlik NPrinting Designer.
14. Now you can create Report template by NPrinting Designer. It is a very simple interface, but still gives a lot of flexibility since it uses Excel formatting and syntax. On the left panel, you’ll note the list of Page, Levels, Images, Tables, Cells, and other options that can be added to the report. To do so, just right-click on the object you want to add and click on “Add Objects” then the object list will pop-up.
Select the corresponding Image objects from “Select Objects” window and click on Ok. QlikSense objects added as images appear the same as in QlikSense. The data is not modifiable.
15. Expand the Images node in the left pane by clicking on the ‘+’ to its left. Drag the QmKECT, TjUVhFD and ruJKJus node tokens into the template and drop each into its own cell.
16. Click on Preview icon at the top left corner to see the result in the native output format of the template.
Wow! In just a few minutes, we’ve managed to set up our connection to a QlikSense Application, create a report, and export it to a folder where users can access it.
Developer Qlik View - Qlik Sense
Laxmi Bhavani is working as a Developer (QlikView and QlikSense) for the past two years, involved in end-to-end implementation of Business Intelligence (BI) projects, especially in modeling, designing scorecards, KPIs, reports, and dashboards. She was also involved in QlikView Server Architecture, NPrinting, Testing and Deployment of Qlikview / Qlik Sense applications. In the past two years, she has worked in several domains viz., Financial, Sales, Transportation, Healthcare, Crime Analytics and Supply Chain performance reporting.