Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Allowing user to set minimums and maximums

Hi Qlik Community,

I have hundreds of thousands of rows of data and I would like to narrow it down. If I want to look at customers that have spent a minimum of $100 and a max of $100, how would I go about doing that while grabbing all the values in between. So far I have been using a multi-value slider but I am curious if there is an easier way.

On any ecommerce site for instance, you can add two values for the min and max that you're willing to pay and it narrows everything down for you. Is there a way to do that here? Just typing in the values rather than having to select all of them. I am creating a dashboard for a client so I'm trying to make it as easy as possible for them to use.

Thanks so much in advance!

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Allowing user to set minimums and maximums

You probably use expressions for the min and max setting of the slider.  When you make a selection that will  change the min and max possible values. The way to prevent that is to add {1} to the expressions, i.e min({1}Value) instead of min(Value).


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
MVP & Luminary
MVP & Luminary

Re: Allowing user to set minimums and maximums

I think the slider is probably the easiest way. But you can also use input boxes for giving variables a value. See attached example


talk is cheap, supply exceeds demand
Not applicable

Re: Allowing user to set minimums and maximums

Thank you! And one last question. When I select the range within the slider, it updates the slider to that specific range and I can't go back to all the values unless I clear all my selections. This seems to only happen with aggregate functions. Any way to clear the slider without clearing all of the other criteria?

I've included some images below. Like if I wanted to go back to the $2k-$4k range how would I be able to do that?

Thanks again for all your help!

MVP & Luminary
MVP & Luminary

Re: Allowing user to set minimums and maximums

You probably use expressions for the min and max setting of the slider.  When you make a selection that will  change the min and max possible values. The way to prevent that is to add {1} to the expressions, i.e min({1}Value) instead of min(Value).


talk is cheap, supply exceeds demand

View solution in original post

Not applicable

Re: Allowing user to set minimums and maximums

That was it! Thank you so much!!!