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
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
Hi,
In the following link under "Adding Filter"
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:
regards
Lech
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