topic Slider not triggering field when a range is selected in QlikView

Slider not triggering field when a range is selected

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone,

I've loaded 2 fields, both with values of 1 to 100. In a slider, I use one of the fields to populate the numbers to select, and then I put a trigger on that field that will select the 2nd field.

This works very wel when I select just 1 value. However, when I turn the slider into a range, it doesn't select anything.

Can anyhow explain why or how to fix? I know this doesn't seem practical, but for what I'm actually working on, it makes sense to do this.

I've attached a sample qlikview,

Thanks!

Re: Slider not triggering field when a range is selected

sunny_talwar — Tue, 12 Sep 2017 18:23:10 GMT

Try with this

='(' & Concat(DISTINCT SliderOptions3, '|') & ')'

Re: Slider not triggering field when a range is selected

Anonymous — Tue, 12 Sep 2017 18:27:41 GMT

Ah Concat... You've used this more than once for the things I ask Sunny... I really need to learn all about it.

Thank you!