How to Create Static and Dynamic Filters Based on Fields

[griffinleow]

Hi 

We are using QlikSense and NPrinting together currently.

In one of our tables, we have a column e.g. category number that ranges from 1 to 1000.

How do I create a dynamic filter in NPrinting that will filter out category number that fulfills a condition? i.e. category number >= 500 and category number <= 750?

So far, I have not been successful in finding relevant documentations or discussion threads on how to solve this in QlikSense and NPrinting.

Appreciate your inputs.

Thank you

[mcsshg2011]

Hi, 

In the following link under "Adding Filter"

https://help.qlik.com/en-US/nprinting/February2019/Content/NPrinting/DistributionSchedulesAutomation...

[Lech_Miszkiewicz]

Hi,

Currently NPrinting 17 and newer does not support search filters (i believe they are on road map though and might be released in future releases).

As of now you can take following steps to built a solution:

https://nprintingadventures.wordpress.com/2019/02/25/the-pitfalls-of-nprinting-filters-part-2-search...

regards

Lech

[Lech_Miszkiewicz · Accepted solution]

the other simpler option is to create a flag in data model during script reload

if(category number >= 500 and category number <= 750, 1,0) as flag_500_750

then in NPrinting you can use filter like:

Field: flag_500_750

Numeric value is: 1

cheers

Lech