NPrinting 16.x allows the use of Advanced searchin 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:
hard coding the From and To dates. Example:
=Date <= Date#('06/22/2019', 'MM/DD/YYYY') and Date>=Date#('06/22/2018', 'MM/DD/YYYY')
Using expressions. Example:
=Date <= num(Today(1)) and Date >=num(Today() - 365)
Using variables that exist in the source document. Example:
=Date>=$(vStartDate) and Date<=$(vEndDate)
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.