Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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.

1 Solution

Accepted Solutions
JordyWegman
Partner - Master
Partner - Master

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

2021-05-19 12_20_59-Qlik NPrinting — Mozilla Firefox.png

 

Jordy

Climber

Work smarter, not harder

View solution in original post

8 Replies
devarasu07
Master II
Master II

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
Creator III
Creator III

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

Frank_S
Support
Support

Thank you Matus,

This is correct.

@Abhay, please see this point above.

best

Qlik Support

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
dwforest
Specialist II
Specialist II

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.

Olip
Creator
Creator

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

- Eager to learn n grow,

Olip
ghaliabed
Partner - Creator
Partner - Creator

Same here

JordyWegman
Partner - Master
Partner - Master

Hi @Frank_S ,

Any  update on this?

Jordy

Climber

Work smarter, not harder
JordyWegman
Partner - Master
Partner - Master

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

2021-05-19 12_20_59-Qlik NPrinting — Mozilla Firefox.png

 

Jordy

Climber

Work smarter, not harder