topic Re: Re: creating numeric search with a tolerance variable in QlikView

creating numeric search with a tolerance variable

Sat, 21 Sep 2013 16:01:58 GMT

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

Re: creating numeric search with a tolerance variable

qlikpahadi07 — Sun, 22 Sep 2013 10:41:27 GMT

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

Simply you can type and press Cntrl and select Multiple Values.
or use Multi Box
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 :

Re: creating numeric search with a tolerance variable

Mon, 23 Sep 2013 12:53:05 GMT

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.

Re: creating numeric search with a tolerance variable

Wed, 25 Sep 2013 04:55:09 GMT

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

Re: creating numeric search with a tolerance variable

qlikpahadi07 — Wed, 25 Sep 2013 05:30:35 GMT

Did you tried Slider Object ?

Re: creating numeric search with a tolerance variable

tresB — Wed, 25 Sep 2013 05:44:18 GMT

Hello Thorsten,

May be like the attached sample ?

Re: Re: creating numeric search with a tolerance variable

qlikpahadi07 — Wed, 25 Sep 2013 10:40:20 GMT

Hi Thorsten Schröder

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

Find the attachment

Re: Re: creating numeric search with a tolerance variable

qlikpahadi07 — Wed, 25 Sep 2013 10:42:08 GMT

Hi Thorsten Schröder

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

Find the attachment

Re: Re: creating numeric search with a tolerance variable

qlikpahadi07 — Wed, 25 Sep 2013 12:35:20 GMT

Nice thoschro this is an easiest way good one tresesco

Re: creating numeric search with a tolerance variable

Fri, 27 Sep 2013 08:09:12 GMT

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