Skip to main content

Member Articles

This forum is for user/member-created articles across the entire Qlik portfolio. Any member that is logged in can create and publish an article here. You must choose the appropriate label in order for the articles to be properly categorized.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW

How to Use QlikView Advanced Search with NPrinting Filters

cancel
Showing results for 
Search instead for 
Did you mean: 
Stefano_Dalla_Guarda

How to Use QlikView Advanced Search with NPrinting Filters

This tutorial illustrates how to create an NPrinting filter, which leverages QlikView advanced search functionality, for use within an NPrinting report.

To create an NPrinting advanced search filter you need to insert the search expression in the filter's field value.

For instance, the formula to find all SalesOffice that start with 'S' appears as follows "=SalesOffice like 'S*' ". According with the QlikView advanced search syntax, the formula to find all SalesOffice that contain an 'S' instead is "=SalesOffice like '*S*' ".

QlikView also allows you to specify a condition to retrieve the values of a field that satisfy a condition based on different fields. For instance, you can select all SalesOffices that sell more than $250,000.00

For the exact Qlikview formula syntax details, refer to your QlikView documentation.

Create a New Filter

                 
            Create-a-New-Filter.png                 
       
  1. Click on Filters in the lower left pane
  2. Click on Filter in the New group in the ribbon
   

Configure Filter

                 
            Configure-Filter.png                 
       
  1. Enter Products Contain 'Shirt'
  2. Enter optionally a Description
  3. Click on Add

Open Select Field Window

                 
            Open-Select-Field-Window.png                 
       

Click on the browse button at the extreme right of the Name field.

Add ProductName Field

                 
            Add-ProductName-Field.png                 
       
  1. Start typing ProductName
  2. Select ProductName from the list
  3. Click on OK

Add an Advanced Formula

                 
            Add-an-Advanced-Formula.png                 
       
  1. Click on the green '+' button to add a new row
  2. Enter =ProductName like '*Shirt*' as Value
  3. Leave Evaluate check box unchecked. Click on OK

If you wish to use advanced search criteria, you must insert an equal character ("=") at the beginning and the "Evaluate" flag must be deselected. Multiple rows of values or advanced search expressions for the same field will be applied in "OR" mode. Refer to "How to Create Static and Dynamic Filters Based on Fields"

  

Save and Close the Filter

                 
            Save-and-Close-the-Filter.png                 
       

Click on Save and Close

 

Open a Report

                 
            Open-a-Report.png                 
       
  1. Click on Reports
  2. Select Excel reports
  3. Select a report and double click on it (e.g. Excel - Simple Report with an Image and a Table)

Apply the Filter to the Report

                 
            Apply-the-Filter-to-the-Report.png                 
       
  1. Click on Filters
  2. Click on Add
  3. Start typing Shirt
  4. Select Product Contain 'Shirt' from the list
  5. Click on OK to apply the filter to the report
  6. Click on Preview

Result

                 
            Result.png                 
       

The report contains only the products that contain the string 'shirt'.

Review also "How to Create QlikView Bookmark Filters Using Dynamic Search Expressions"

Labels (1)
Version history
Last update:
‎2015-11-06 06:10 AM
Updated by: