topic Re: nPrinting Filters - How to use greater than operator in Qlik NPrinting

nPrinting Filters - How to use greater than operator

Anonymous — Wed, 25 Sep 2019 18:40:54 GMT

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:

The above syntax doesnt work. Any help is appreciated.

Re: nPrinting Filters - How to use greater than operator

devarasu07 — Sat, 21 Oct 2017 09:21:52 GMT

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.

refer

Nprinting filters > value | Qlik Community

thanks Deva

Re: nPrinting Filters - How to use greater than operator

mkelemen — Mon, 23 Oct 2017 11:33:47 GMT

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

Re: nPrinting Filters - How to use greater than operator

Frank_S — Tue, 24 Oct 2017 14:56:54 GMT

Thank you Matus,

This is correct.

@Abhay, please see this point above.

best

Qlik Support

Re: nPrinting Filters - How to use greater than operator

dwforest — Tue, 23 Jan 2018 21:44:08 GMT

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.

Re: nPrinting Filters - How to use greater than operator

Olip — Wed, 11 Apr 2018 19:22:33 GMT

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

Re: nPrinting Filters - How to use greater than operator

ghaliabed — Thu, 07 Jun 2018 06:22:27 GMT

Same here

Re: nPrinting Filters - How to use greater than operator

JordyWegman — Wed, 19 May 2021 10:00:41 GMT

Hi @Frank_S ,

Any update on this?

Jordy

Climber

Re: nPrinting Filters - How to use greater than operator

JordyWegman — Wed, 19 May 2021 10:21:38 GMT

Nevermind, I've found that the possibility is there now:

Jordy

Climber