topic Re: field event trigger, deselection to deselect another in QlikView

field event trigger, deselection to deselect another

Tue, 13 May 2014 08:40:03 GMT

Hi all,

I have an issue whereby I make selections in a list box (A) and I have a trigger which makes the same selection in another list box (B). However, when I clear list box A, list box B remains selected. Does anyone know of a trigger that would sort this issue as I thought it would be relatively simple to do.

Thoughts appreciated

Thanks

Re: field event trigger, deselection to deselect another

alexandros17 — Tue, 13 May 2014 08:42:37 GMT

Use alternate states (take a look in help)

Let me know!

Re: field event trigger, deselection to deselect another

simondachstr — Tue, 13 May 2014 08:43:25 GMT

Copy the event triggers to be included in OnChange as well.

Re: field event trigger, deselection to deselect another

SunilChauhan — Tue, 13 May 2014 08:44:03 GMT

use clear all action even trigger

or check if

one value always selected opetion is check

if so un check

it would be avialable in general tab of properties

hope this helps

Re: field event trigger, deselection to deselect another

Tue, 13 May 2014 10:14:40 GMT

Copying the event trigger to on change as well doesn't give any change in the result when deselecting unfortunately.

my trigger for onselect to make selection in B when A is selected works fine, but the deselection does not follow in same pattern.

Re: field event trigger, deselection to deselect another

Tue, 13 May 2014 10:16:28 GMT

Thanks,
I don't think alternate states will produce the desired effect. one field (B) will be hidden but will be selected when field A is selected - I don't see how alternate stats will work when i deselect A to make B get deselected as well.

Re: field event trigger, deselection to deselect another

Tue, 13 May 2014 10:18:39 GMT

Hi Sunil,

I don't to clear all though, I just wish to mirror A's selections, i.e. when I deselect A so that nothing in A is selected B also clears it's selection.

Re: field event trigger, deselection to deselect another

Tue, 28 Oct 2014 20:07:16 GMT

Hi Brendan, did you ever sort this out? I am looking to solve the exact same issue, in the same scenario.

Re: field event trigger, deselection to deselect another

Tue, 07 Jul 2015 14:23:18 GMT

I found some solution. In my case I needed select on another list box exactly the same value. So I did something like that:
1) in Document Properties (ctrl+alt+d) I chose my field in Field Event Triggers and I clicked OnSelect Add Action(s).

2) I added Select in Field.

3) in Field I wrote name of second list box and in Search String I use this:
=IF( GetSelectedCount(My_field)>0, '(' & CONCAT(DISTINCT My_field, '|') & ')')

and I clicked OK button.

4) I clicked OnChange Add Action(s).

5) I added Clear Field.

6) In Field I wrote: =IF( GetSelectedCount(My_field)=0, 'My_field_2')

7) And that's it. It should work.

Maybe it'll help someone.

Re: field event trigger, deselection to deselect another

RGeorgieva — Thu, 16 Nov 2017 10:06:02 GMT

It works for me. Thank you Monika Piątkowska

Re: field event trigger, deselection to deselect another

linda_wimmer — Fri, 23 Feb 2018 13:35:10 GMT

Hi Brendan,

I believe Monika gave us the solution, it works perfectly for me.

Regards,

Linda

Re: field event trigger, deselection to deselect another

linda_wimmer — Fri, 23 Feb 2018 13:36:10 GMT

I guess question can be set to Answered

Re: field event trigger, deselection to deselect another

linda_wimmer — Fri, 23 Feb 2018 13:37:00 GMT

Hi Monika,

It helped me a lot. Thank you for sharing your tip