topic Filtering with Slider in QlikView

Filtering with Slider

Tue, 22 Jan 2013 23:47:32 GMT

Folks,

I have a dashboard finished dashboard, with charts, tables and filters.

However, now I'll have to substitute one filter by a slider object, so the user can select the range.

I created the variables for maximum and minimun values and the slider object, but now I would like to have your help in order to make thisslioder selection affect all the object just like any other regular filter.

Thanks.

Re: Filtering with Slider

Wed, 23 Jan 2013 00:14:48 GMT

You would use the variables in the expression of the relevant items or have the field associated with the slider. See this post for an example.

http://community.qlik.com/qlikviews/1075

Cheers!

Re: Filtering with Slider

Wed, 23 Jan 2013 11:48:58 GMT

Thanks For the Answer.

There's no way to the selected value on the slider affect the filter directly ?

Re: Filtering with Slider

jagan — Wed, 23 Jan 2013 11:55:59 GMT

Hi,

The selected value in the slider doesn't affect the filters directly, you need to use the variables in the expression to filter the values in the chart.

Regards,

Jagan.

Re: Re: Filtering with Slider

Anonymous — Wed, 30 Apr 2014 13:38:30 GMT

Yes.

You can configure the slider with a Field from your datamodel, which if set in "Multi Value" mode will let the user slide and select a range of existing values from that Field.
If your data does not have the desired Min/Max values you could generate data and link it to the desired field, and let the user Slide in the linked field instead. That way the selections will affect all data as all possible values in your original Field are included when sliding. But, the user could slide to a range not present in your Field, and that would make all your objects empty, see attached example. As I don't know your data, this might not work for you.
Jagan's approch adding the variables in the expressions where the slider should have effect is not that difficult either.