NPrinting: Creating Static and Dynamic Filters Based on Fields

• Static filters based on field values
• Dynamic filters based on expressions in QlikView syntax
• Filters based on QlikView Advanced Search

Filters based on fields can use both existing field values and also values which do not currently exist in the data (this may be useful for slowly changing fields).

Dynamic filters use QlikView syntax expressions which are calculated at run time and then applied to the filter field. You can only use expressions whose output is a single value (e.g. "year(now())").

To create a search expression that involves search criteria for associated fields and full boolean logic you can use QlikView Advanced Search that is supported by NPrinting and explained in the tutorial "How to Use QlikView Advanced Search with NPrinting Filters".

The use of QlikView Bookmarks is still supported (see: Creating NPrinting Filters Based on Existing QlikView Bookmarks) but we suggest the use of the Advanced Search feature when you need to create complex dynamic filters.

NPrinting allows users to associate filters with Tasks, Recipients and Reports. It is also possible to apply one specific filter to a table or an image inside a report (refer to How to Apply a Specific Filter to Tables or Images).

Filters are applied in a specific order: Task filters are applied first, then Recipient filters, and finally Report filters. This may have an impact on which values are in the final data set created for any given report. NPrinting filters are applied in the same way and with the same logic as filters applied by a QlikView user using the QlikView desktop application.

Environment:

• NPrinting 16