Filter filed that contains like string

[gal_polak]

Hi all, 

I'm trying to add a filter in NPrinting to one of my reports, 

i have a list of products and i want the reports to bring me all products that there name starts with:

'Baa*'

how can i do that?

[Lech_Miszkiewicz]

Hi,

Filter in NPrinting needs to evaluate to single value or be represented as a list values. Wildcard is not supported.

se here

Static filters let you select a list of values from QlikView or Qlik Sense fields. You must manually edit the filter to change values.

Dynamic filters use QlikView or Qlik Sense formulas. Formulas must use QlikView or Qlik Sense rules and syntax, and return a single value. Formulas are evaluated, and the results are used to filter data. You do not have to modify dynamic filters to gain new values.

My suggestion is to create logic in Qlik Load script and create a grouping field in which your wildcard will be represented as a single value which you can point to in your NPrinting filters.

regards

Lech

 BY THE WAY - ALWAYS specify version of Qlik & NPrinitng +SR you are using!

[gal_polak · Accepted solution]

Well i'll update for the help of others, 

In June 2020 it is possible to use the "Advance search" with "*" -> this basically use wildcard in Qlik 

[Lech_Miszkiewicz]

@gal_polak 

Advanced search is available since 2019 June so for quite a long time already... more here:

https://nprintingadventures.com/2019/06/26/nprinting-filters-part-3-advanced-search/