Qlik Community

Qlik NPrinting Documents

Documents related to Qlik NPrinting.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.

How to Apply a Specific Filter to Tables or Images

Support
Support

How to Apply a Specific Filter to Tables or Images


Description: This tutorial explains how to associate a filter on a specific table or image object. The "Properties" section of tables and images has the Filter field to let you select an existing filter. You can associate only one filter to each table or image. This gives you the ability to aggregate all your filtering information in a single filter.

Consider that the report performance upon preview or task generation action can be affected by table and image filters because NPrinting will have to perform a single filter application and export for each filtered object.

Object filters are the last to be applied which means they have the highest priority.

The filter application sequence is (lowest priority to highest priority): Task - Recipient - Cycle - Report - Level/Page - Object.

To get consistent output, please keep the following in mind:

1- if the object filter contains selections for fields that are already selected by other filters, the object filter will replace them

2- if the filter contains selections for fields that have never been selected, the object filter will be applied in addition to the current selections

3- if the object filter is a "Clear Selections" type filter, then the object will be affected by all filters other than selections to the field specified in the "Clear Selections" filter

NOTE: Filters based on Linked Fields are not allowed.

Add Filters to the Chart

Add-Filters-to-the-Chart.png

After adding a chart as image or table in a new template:

  1. Right click on the table node
  2. Select Properties
  3. Click on the three dots button. You can also clear all applied filters by clicking on the eraser button to the left of the three dots button.
Also see

Select the Filter to be Added to the Image

Select-the-Filter-to-be-Added-to-the-Image.png
  1. Select Category
  2. Click on OK

Create the Template

Create-the-Template.png

  1. Select the CH306 table
  2. Drag and drop it
  3. Click on the Preview button

Result

Result.png

The chart has been filtered by the Category filter

Version history
Revision #:
1 of 1
Last update:
‎2015-11-19 04:29 PM
Updated by: