Discussion Board for collaboration on Qlik NPrinting.
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.
Go to Solution.
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.
View solution in original post
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.
Nprinting filters > value | Qlik Community
Thank you Matus,
This is correct.
@Abhay, please see this point above.
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.
Anything update on this thread. I am also surprised that basic functionality such greater than or less than cannot be used in Filters.