Question about search in a range of numbers.
Let's say I have the number 2.050. I would like to find the nearest number and then select the data in the second column.
Could one you explain to me how to do this?
Solved! Go to Solution.
Are you working with Personal Edition?
Here are my expressions, vValue holds the value you're looking for the nearest one
I'm using QV11.1 with Named User cal, so I'm not sure what the problem is.
I used your expressions, they are perfect.
Since I do have a list of numbers I would like to find, is it possible to do this without a variable?
The output I would like to have is:
Thanks, that works for me.
In the help I read this:
If more than one value of expression share the same lowest sort-order, the function will return NULL.
By stating an n larger than 1, the nth value in order will be returned. If the word distinct occurs before the expression, all duplicates will be disregarded.
Could you please tell me how to add this to the expression?
Thanks a lot.
You can see that in the help samples.
firstsortedvalue ( distinct PurchasedArticle, OrderDate )
If you have problems with ties just add a rand() to the input values or something like that.