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.
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.
Create New Filter
Click on Filters in the lower left pane
Click on Filter in the New group in the ribbon
This opens the Filters window
Give the filter a Name
Optionally enter a Description
Click on the Add button in the Fields group to add one or more fields to your filter
Open Select Field Window
Click on the browse button at the extreme right end of the Name field.
Select Field(s) You Want to Use in Your Filter
Select the Connection to the QlikView document that contains the fields you want. The SelectField window lists all available QlikView documents and the fields they contain
Scroll down to and select the Year field
Click on the OK button to add the field
Select Existing Field Values to Add to Filter
Click on the Add Values button in the Field window, which opens the Select Values window listing all the values for that field present in the QlikView document
You can select one or more values (use Shift or Ctrl +Click)
Click on the OK button at the bottom of the Select Values window
Add New Value
You can add values to the filter manually for values not present in the QlikView file.
Click on the green '+' button to add a new row below the existing values in your filter
Click on the cell in the new row in the Value column and enter any year value. Any data related to that value will be included in the report if and when that data becomes available in the QlikView document
Click on the corresponding box in the IsNumeric column so that it is checked
Enter the numeric value corresponding to the string of numeric characters that has been entered in the Value column
You can delete rows with values you do not want
Select the row(s) you want to delete
Click on the red '-' button
Click on OK in the Confirm dialog to delete the selected rows
Conclude by clicking on OK in the Field dialog window
Add an Expression in QlikView Syntax
You can create filters based on expressions in QlikView syntax. The limitation is that any expression to be passed by NPrinting to QlikView for evaluation must return a unique value compatible with the selected field. For instance, "year(now())" returns a unique integer value compatible with the field Year. "Year>2010" returns a unique value, however, it is boolean (true or false) which is therefore not compatible with the Year field which is an integer. Also ">year(now())" and "2014>year(now())" are incorrect.
There are five filter parameters in NPrinting field filters. You can set one or many of these parameters when you create your filter. Parameters are applied in the order that filters are applied (first Task filters, then Recipient filters and finally Report filters).
1. Locked: this will lock this field; if there are other filters based on this field in NPrinting, they will not be applied.
2. Verify filter: this will do two things:
a) If a filter withVerify filter is applied and the resulting data set is empty, then NPrinting will not generate a report. This can be used to do conditional reporting.
b) If a filter withoutVerify filter is applied, NPrinting try to select values that not exist in the .qvw. In this case QlikView enables all values so NPrinting will generate a report with the unfiltered dataset. For instance, if you filter for France and 2013 but there were no sales in France in 2013, NPrinting will create a report with sales on all other countries.
3. Select Excluded: If you select this check box, you will filter for all of the values of the field that you DID NOT select (e.g. you filter Male for Gender and use the Select Excluded parameter, then the report will be filtered for Female)
4. Drop Field (in reduce): If you select this check box, when you run a reduce Task, the resulting QlikView QVW will not contain that field
5. Unlocked if Locked: this will unlock fields that are locked in Qlikview
Save Field, Values and Parameter Settings
Click on OK to save the field, values and parameters settings
Click on Save and Close to save and close the filter