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.
If you are new to Qlik NPrinting or just want to brush up on your NPrinting report development skills, we have good news for you.
You can find a vast wealth of training videos at the following link:
Once you arrive on this page, just click the "Qlik NPrinting" link under "Filter on products" to access the training videos. You may also of course choose any of the other Qlik product training video links as well as needed.
If needed, you can also filter on product version as well in case you are running an older version of NPrinting.
You will also find written NPrinting Design tutorials here:
Note: It is very important for normal, unimpeded NPrinting report design to keep in mind that the NPrinting designer must be the same version as the NPrinting Server and should not be upgraded independently. You will need to contact your NPrinting Administrator to request an entire NPrinting system upgrade if you need a newer version of the NPrinting Designer.
If you have an issue to report regarding your NP designer, please type your query into the Qlik Community Search, start a new community discussion thread or contact the Qlik Support Desk or your Qlik Support Partner as needed.
(NPrinting 16 training information may be found here: https://community.qlik.com/t5/Qlik-NPrinting-Documents/QlikView-NPrinting-16-Training-amp-Installation-Upgrade/ta-p/1489063)