Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Ok, i found a solution that worked:
=IF((FIELD>=0) + ( FIELD <=100) = -2,-1,Null())
if you have other suggestions let me know
Ok, i found a solution that worked:
=IF((FIELD>=0) + ( FIELD <=100) = -2,-1,Null())
if you have other suggestions let me know
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
also make sure when you write an expression for a filter, you check the evaluate option (and numeric if needed)
Eike
any new info or headway on this?
Generally you are right, but in this case i want to use it as a search term. So you have to uncheck evaluate.
see above