topic Re: Use a Slider / Variable as a Filtering Tool in QlikView

Use a Slider / Variable as a Filtering Tool

dmac1971 — Thu, 05 Jun 2014 12:46:25 GMT

If I have a table of data and I want to say only show a percentage result less than 60% is it possible to have a slider, linked to a variable if need be, that I can use to do this? IE change the slider value will filter the table results?

Re: Use a Slider / Variable as a Filtering Tool

Thu, 05 Jun 2014 12:48:59 GMT

I think you can use the input slider's variable in your expression's set analysis to achieve what you want.

Re: Use a Slider / Variable as a Filtering Tool

Thu, 05 Jun 2014 12:49:43 GMT

you can use options in tab "Dimension limits"

it shoud fit simply your needs

otherwise use a variable and use it in the expression to filter data

best regards

chris

Re: Use a Slider / Variable as a Filtering Tool

Thu, 05 Jun 2014 12:52:33 GMT

Christianj is correct. Under dimension limits, select "restrict which values are displayed using the first expression", then select "show only values that are:".

Select "Less than" and then insert your slider variable into the percentage field.

Re: Use a Slider / Variable as a Filtering Tool

Mon, 23 Jun 2014 19:48:07 GMT

hi ,

how can I do this with a lower bound value and a upper bound value i.e. between variable 1 and variable 2 ?

slider is working with multiple value.

Thanks in advance;

Guy