topic Re: NPrinting - numeric Search Filter in Qlik NPrinting

NPrinting - numeric Search Filter

eike_s — Thu, 17 Dec 2015 16:07:14 GMT

Hey,

i am facing a Problem with filters (import). I want to select a range of values for a field eg. value 0-100. I thought i could use something like >=0<=100 as search term but in every combination i set the filter i get an error. I want to avoid creating a list with all the values in between. Any Ideas? thanks.

Re: NPrinting - numeric Search Filter

eike_s — Thu, 17 Dec 2015 16:17:56 GMT

Ok, i found a solution that worked:

=IF((FIELD>=0) + ( FIELD <=100) = -2,-1,Null())

if you have other suggestions let me know

Re: NPrinting - numeric Search Filter

Thu, 17 Dec 2015 17:38:30 GMT

one option you can try is to define a variable for your date range and build the filter off of the variable. I have a date range in my QV app and crated a filter using that variable and it worked

you should be able to write qv logic within the filter - what I do is I go into an NPrinting template and write what I want my filter code to be in a formula - the formula will show you the results of the expression - then I paste what I wrote in the formula into the filter

Re: NPrinting - numeric Search Filter

Thu, 17 Dec 2015 17:50:38 GMT

also make sure when you write an expression for a filter, you check the evaluate option (and numeric if needed)

Re: NPrinting - numeric Search Filter

Fri, 18 Dec 2015 13:01:35 GMT

Eike

any new info or headway on this?

Re: NPrinting - numeric Search Filter

eike_s — Thu, 07 Jan 2016 15:39:40 GMT

Generally you are right, but in this case i want to use it as a search term. So you have to uncheck evaluate.

Re: NPrinting - numeric Search Filter

eike_s — Thu, 07 Jan 2016 15:45:36 GMT

see above