topic Re: Allowing user to set minimums and maximums in QlikView

Allowing user to set minimums and maximums

Thu, 14 May 2015 19:00:19 GMT

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!

Re: Allowing user to set minimums and maximums

Gysbert_Wassenaar — Fri, 15 May 2015 08:16:34 GMT

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

Re: Allowing user to set minimums and maximums

Fri, 15 May 2015 17:00:28 GMT

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!

Re: Allowing user to set minimums and maximums

Gysbert_Wassenaar — Fri, 15 May 2015 17:07:45 GMT

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).

Re: Allowing user to set minimums and maximums

Fri, 15 May 2015 17:15:45 GMT

That was it! Thank you so much!!!