Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Highlighted
Partner
Partner

How to Create Static and Dynamic Filters Based on Fields

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

1 Solution

Accepted Solutions

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

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

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
3 Replies
mcsshg2011
New Contributor III

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

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

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

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

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

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

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.