topic Re: Field selection in Listbox (Trigger actions in sheet) does not work in QlikView

Field selection in Listbox (Trigger actions in sheet) does not work

hansdevr — Sat, 16 Nov 2024 20:30:54 GMT

I want to pre-select 'INTERFACE' in the Broncode field on opening of a certain sheet.

See attached picture. Any idea why it REFUSES to work for me?

Re: Field selection in Listbox (Trigger actions in sheet) does not work

gf — Fri, 05 Jul 2019 07:47:32 GMT

Hello Hansdevr,

Try ='IN*'

Should work.

Regards!

Re: Field selection in Listbox (Trigger actions in sheet) does not work

hansdevr — Fri, 05 Jul 2019 07:51:32 GMT

Hi gf,

Maybe it should, but it doesn't...

Re: Field selection in Listbox (Trigger actions in sheet) does not work

gf — Fri, 05 Jul 2019 07:55:09 GMT

Hello,

I tried it myself and it works fine.

Regards.

Re: Field selection in Listbox (Trigger actions in sheet) does not work

gf — Fri, 05 Jul 2019 07:56:29 GMT

Is Broncode your header or the real field name?

Re: Field selection in Listbox (Trigger actions in sheet) does not work

hansdevr — Fri, 05 Jul 2019 08:00:40 GMT

It definitely is the real name of the field. I also added the alternate state for this sheet.

Re: Field selection in Listbox (Trigger actions in sheet) does not work

gf — Fri, 05 Jul 2019 08:02:29 GMT

ah i see try
='IN*'
you forgot the "="

Re: Field selection in Listbox (Trigger actions in sheet) does not work

hansdevr — Fri, 05 Jul 2019 08:06:11 GMT

......no show.....

Re: Field selection in Listbox (Trigger actions in sheet) does not work

gf — Fri, 05 Jul 2019 08:08:38 GMT

Can you upload your project without data?

I will have a look at it.

Re: Field selection in Listbox (Trigger actions in sheet) does not work

hansdevr — Fri, 05 Jul 2019 08:11:40 GMT

Alas, rules in my firm are extremely strict on this.

I saved the action, saved the qvw, opened it again, did a reload, but still no show...

It's driving me up the walls, but at the same time it's no biggie.

Re: Field selection in Listbox (Trigger actions in sheet) does not work

hansdevr — Fri, 05 Jul 2019 08:20:13 GMT

Somehow I fixed it.

Your search string actually worked, but I had to put the trigger action into the Document properties..

Thnx very much for pointing me in the right direction, although it is still beyond me why it failed in the Sheet properties..

Re: Field selection in Listbox (Trigger actions in sheet) does not work

gf — Fri, 05 Jul 2019 08:21:06 GMT

Ok last try 😄

Go to Document Properties.

Tab Triggers

In Document Event Triggers select OnOpen then click button Add Action(s)

In the Actions dialog click the Add button

Action Type: Selection

Action: Select in Field

Click OK

In Actions dialog

Field : Name

Search String : ='IN*' ,include the '='

Click OK

Then save the project, close it and open it again.

Re: Field selection in Listbox (Trigger actions in sheet) does not work

hansdevr — Fri, 05 Jul 2019 09:20:00 GMT

.....which is EXACTLY what I did (see my previous post) and that worked!