topic Re: Trigger Selected Fields won't clear in QlikView

Trigger Selected Fields won't clear

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

Hi All,

I searched a few times for an answer for this, since it seems like I'm missing something simple.

I have a field [SliderOptions] that I use for a slider, from that a trigger selects options in [Score]. The trigger select is:

='(' & Concat(DISTINCT [SliderOptions], '|') & ')'

The problem is, when I make a selection on the slider and then hit 'clear' at the top, the [SliderOptions] clear but the [Score] selects everything. Can someone help me determine why? And a way to make the clear work in this format?

I've attached a sample.

Note: hitting clear twice will clear everything, I know, but I'd like it to do it the first time.

Thanks!

Re: Trigger Selected Fields won't clear

krishnacbe — Wed, 15 Nov 2017 15:03:53 GMT

Try below expression in your trigger.

=if(GetSelectedCount(SliderOptions)>=1, '(' & Concat(DISTINCT [SliderOptions], '|') & ')')

Re: Trigger Selected Fields won't clear

Anonymous — Wed, 15 Nov 2017 15:06:49 GMT

This works! Thank you!

Re: Trigger Selected Fields won't clear

YoussefBelloum — Wed, 15 Nov 2017 15:09:52 GMT

Hi,

Just added a condition on the Trigger to check if the Slider Is null

check attached