creating numeric search with a tolerance variable

[#1]

Hello community,

I want to give users the opportunity to search within a numeric measurement column where they can also set a tolerance to search in between a given range of the entered number.

Example:

User wants to search for all products with a certain measurement of 5.4 but also list all products that are +- 0.25 away from the given number. So the result should list all products between 5.15 and 5.65.

Can this be done? I would first need some user friendly way to provide this search functionality. For example if I type in 5.4 in the search of a listbox how could I incorporate the range variable so that there is no complicated typing required?

I'd be grateful if you could provide a sample how this task can be achieved.

Thank you,

Thorsten

[qlikpahadi07]

Yes it can be with Several ways..

Back end

1. You can create a Bucket from your backend

2. or with help of If and Else you can group your data.

for Front end

1. Simply you can type and press Cntrl and select Multiple Values.
2. or use Multi Box
3. for Range you can simply select the list box and type >1<1.11  this will give you a Range then select the options see the Screen shot for this :

[#3]

I don't think this is what I'm looking for or I don't understand it. Also entering >1<1.11 is too much trouble for my users 🙂

My idea is that I can set the tolerance variable with a slider then I have an input box to set the actual value I'm looking for and this gets combined to a search variable I could use in a listbox.

But maybe there are simpler ways than that.

[#4]

No other ideas? There must be a way to get this done.

[qlikpahadi07]

Did you tried Slider Object ?

[tresesco · Accepted solution]

Hello Thorsten,

May be like the attached sample ?

[qlikpahadi07]

Hi Thorsten Schröder

Yes, there are I have created a Demo for you may be helpful let me know.

Find the attachment

[qlikpahadi07]

Hi Thorsten Schröder

Yes, there are I have created a Demo for you may be helpful let me know.

Find the attachment

[qlikpahadi07]

Nice thoschro this is an easiest way good one tresesco

[#10]

thank you very much. This should do what I need it to do 🙂