Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

creating numeric search with a tolerance variable

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

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Hello Thorsten,

May be like the attached sample ?

View solution in original post

9 Replies
qlikpahadi07
Specialist
Specialist

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 :
Not applicable
Author

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.

Not applicable
Author

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

qlikpahadi07
Specialist
Specialist

Did you tried Slider Object ?

tresesco
MVP
MVP

Hello Thorsten,

May be like the attached sample ?

View solution in original post

qlikpahadi07
Specialist
Specialist

Hi Thorsten Schröder


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



Find the attachment

qlikpahadi07
Specialist
Specialist

Hi Thorsten Schröder


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



Find the attachment

qlikpahadi07
Specialist
Specialist

Nice thoschro this is an easiest way good one

Not applicable
Author

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