topic Re: Default setting in ListBox with Trigger in QlikView

Default setting in ListBox with Trigger

Anonymous — Tue, 27 Feb 2018 06:58:13 GMT

Hello,

I will use Sheet Properties to set a default setting. With Sheet Event Triggers 2 Values on ListBox (“AD“ und “AS“) should be selected. If I leave this sheet Trigger “OnLeaveSheet” setting in ListBox should be clear.

Regards

Stefan

Re: Default setting in ListBox with Trigger

jonathandienst — Tue, 27 Feb 2018 07:01:47 GMT

And your question is?

Re: Default setting in ListBox with Trigger

Anonymous — Tue, 27 Feb 2018 07:07:55 GMT

How does a Trigger works, how is the formula?

Re: Default setting in ListBox with Trigger

jonathandienst — Wed, 28 Feb 2018 04:38:07 GMT

The "Select in Field" formula would be (AD|AS)

On exit, use a "Clear Field " action

Re: Default setting in ListBox with Trigger

Anonymous — Wed, 28 Feb 2018 08:12:25 GMT

Trigger ist not working?

Re: Default setting in ListBox with Trigger

Qrishna — Wed, 28 Feb 2018 08:41:31 GMT

Check out the attached qvw.

result:

Re: Default setting in ListBox with Trigger

Anonymous — Wed, 28 Feb 2018 09:02:48 GMT

Now, Trigger is working fine.

character = was missing

Solution:

(Action) Select in Field

(Field) Site2

(Search String) ='(AD|AS)'