Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

sudhakaran_abha
Contributor

nPrinting Filters - How to use greater than operator

Qlik Sense.png

In a nPrinting Report, I would like to fetch only rows that have value greater than '$30,000'. Not sure what is the correct syntax for this:

2017-10-20 13_13_03-Clipboard.png

The above syntax doesnt work. Any help is appreciated.

Tags (1)
1 Solution

Accepted Solutions
mkelemen
Contributor III

Re: nPrinting Filters - How to use greater than operator

Hi Abhay,

the example by Devarasu works only in NP 16.

Quoting Stephen Jasionowski from thread Advanced Search filters in NPrinting 17.5

     It's not supported currently but is on the roadmap.

     At this time, NPrinting 17 filters can only return a single value, not an array like is possible in NPrinting 16.


BR,


  Matus

6 Replies
devarasu07
Honored Contributor II

Re: nPrinting Filters - How to use greater than operator

Hi,

I've Nprint 16.x and attached sample steps It should work in Nprinting 17 as well.

your case try like this

1) add you measure as filter (enable verify filter and is numeric option is check then ad filter  value as

= Exp1>30000 then save your filter and ad filter into your excel template /report.

1.JPG

2.JPG

3.JPG

refer

Nprinting filters > value | Qlik Community

thanks Deva

mkelemen
Contributor III

Re: nPrinting Filters - How to use greater than operator

Hi Abhay,

the example by Devarasu works only in NP 16.

Quoting Stephen Jasionowski from thread Advanced Search filters in NPrinting 17.5

     It's not supported currently but is on the roadmap.

     At this time, NPrinting 17 filters can only return a single value, not an array like is possible in NPrinting 16.


BR,


  Matus

Employee
Employee

Re: nPrinting Filters - How to use greater than operator

Thank you Matus,

This is correct.

@Abhay, please see this point above.

best

Qlik Support

dwforest
Valued Contributor

Re: nPrinting Filters - How to use greater than operator

What version of 2018 is this going to be in?

It seems odd to lose such important functionality; It is unrealistic to have to create a flag for every possible filter when a range would have sufficed.

alip_nath
Contributor

Re: nPrinting Filters - How to use greater than operator

Anything update on this thread. I am also surprised that basic functionality such greater than or less than cannot be used in Filters.

ghaliabed
New Contributor

Re: nPrinting Filters - How to use greater than operator

Same here

Community Browser