topic Re: How to Create Static and Dynamic Filters Based on Fields in Qlik NPrinting

How to Create Static and Dynamic Filters Based on Fields

griffinleow — Sat, 16 Nov 2024 03:52:39 GMT

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

Re: How to Create Static and Dynamic Filters Based on Fields

mcsshg2011 — Fri, 12 Apr 2019 04:36:56 GMT

Hi,

In the following link under "Adding Filter"

https://help.qlik.com/en-US/nprinting/February2019/Content/NPrinting/DistributionSchedulesAutomation/Distribute-User-Specific.htm

Re: How to Create Static and Dynamic Filters Based on Fields

Lech_Miszkiewicz — Fri, 12 Apr 2019 05:32:08 GMT

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-string-filters/

regards

Lech

Re: How to Create Static and Dynamic Filters Based on Fields

Lech_Miszkiewicz — Fri, 12 Apr 2019 05:36:48 GMT

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