Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
griffinleow
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

Labels (4)
1 Solution

Accepted Solutions
Lech_Miszkiewicz

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.

View solution in original post

3 Replies
mcsshg2011
Contributor III
Contributor III

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

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.
Lech_Miszkiewicz

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.

View solution in original post