Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted
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

View solution in original post

6 Replies
Highlighted
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

Highlighted
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

View solution in original post

Highlighted
Support
Support

Thank you Matus,

This is correct.

@Abhay, please see this point above.

best

Qlik Support

We are just 'like' you & like to be liked when we provide a helpful answer and or when you press the 'Solution Accepted' button if an answer provided resolves your question or issue... Cheers!
Highlighted
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.

Highlighted
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
Highlighted
Partner
Partner

Same here