This article explains how to connect a single Qlik NPrinting June 2019, or newer, to multiple Qlik Sense servers.
The procedure is the same used to connect Qlik NPrinting to a single Qlik Sense server and it is documented on the help site page: http://help.qlik.com/en-US/sense/June2019/Subsystems/ManagementConsole/Content/Sense_QMC/export-certificates.htm.
Open the Qlik Sense server management console (QMC) and select Certificates, the last left menu option.
Click on Add machine name, insert the Qlik NPrinting server name and flag the option Include secret key.
Click on Export certificates to run the export. When finished the certificate files will be available in a subfolder with the Qlik NPrinting server name of the displayed folder of the Qlik Sense server (by default C:\ProgramData\Qlik\Sense\Repository\Exported Certificates\QlikNPrintingServerName).
Connect with the Qlik Sense server via RDP (Remote Desktop Console) or open the folder via file explorer. Rename the client.pfx file with a unique name of your choice. We suggest to use the Qlik NPrinting server name.
In the file explorer, open the Qlik NPrinting server folder where the Qlik Sense certificates are stored, typically C:\Program Files\NPrintingServer\Settings\SenseCertificates.
Copy the renamed client.pfx certificate file in that folder.
In this folder you can copy a certificate for each Qlik Sense server you want to connect to. You can set the certificate file names you prefer, Qlik NPrinting will automatically identify the correct one to be used for each connection.
Note 1: The Qlik NPrinting server folder with Qlik Sense certificates (C:\Program Files\NPrintingServer\Settings\SenseCertificates) is kept during Qlik NPrinting upgrades but is deleted when you uninstall Qlik NPrinting.
Create a Qlik NPrinting connection to the new Qlik Sense server as documented in: http://help.qlik.com/en-US/nprinting/June2019/Content/NPrinting/GettingStarted/HowCreateConnections/Connect-to-QlikSense-apps.htm.
Click on Run verification: all flags must be green.
Wait until the metadata reload is completed without issues.
You can now create a new report, or modify an existing one, by using data from the new Qlik Sense connection.
You can also insert data from multiple Qlik Sense and QlikView connections in the same report template.
Note 2: Connecting additional Qlik Sense servers will have an impact on NPrinting server system resources. Ensure to carefully monitor NPrinting Server/NPrinting Engine RAM memory and CPU usage and increase each respectively as needed to ensure normal NPrinting server/engine system operation.
Note 3: you can publish Qlik NPrinting reports only to one Qlik Sense Hub, the one defined in the Destinations. Publishing in multiple Qlik Sense Hubs it is still not supported.
NPrinting 16.x allows the use of Advanced search in filters. Now NPrinting June 2019 gives us this functionality with the introduction of a new filter type called Advanced search. Here are a few examples of how it can be used.
Note: I have made a few changes to a copy of the sample Qlik Sense App found here and used that as the Connection source for these examples. The modified App and exported report are attached to this post.
Fields that exist in the source document that we use:
Variables that exist in the source document that we use:
Filtering for a date range.
With Advanced search filters you can filter for a date range in any of these ways:
Note: The above filters were defined on the Date field. You can also define the same filters for other fields just as you can use expression search in the source document if you want to search for values in associated fields. For example you could use the exact same filter definition for the Customer field to get different results:
Screenshots of the Filter editor showing the difference:
Filtering for the Top n
Here is an example using Advanced search filters and Aggr() to filter for the Top 10 Customers (most Sales). You can of course use a variable or an expression that results in an integer instead of hard-coding the number 10.
Filtering for a range
Similar to example 1. Here again you can use variables or expressions instead of hard-coding the numbers.
Example using aggr() to get Customers with Sales above average but also less than or equal to $160,000
=sum(Sales)>Avg(TOTAL Aggr(Sum(Sales),Customer)) and sum(Sales)<=160000
Filtering using wildcards
Advance search filters supports the use of wildcards. This example filters for all Customer names that begin with IB or end with EX
I'm very excited to see the myriad ways this powerful feature will be used going forward. I hope this short introduction gets you started.
To set up the example project:
Hello all Qlik NPrinting users!
I am pleased to announce that the June 2019 Qlik NPrinting release is now available.
The Qlik NPrinting June 2019 release includes notable features that provide an improved user experience and streamlined report authoring and execution efficiencies.