topic Re: Action "activate sheet" don't trigger "on activate" in QlikView

Action "activate sheet" don't trigger "on activate"

nicolas_martin — Fri, 26 Oct 2018 08:16:00 GMT

Hello,

I have some triggers "OnActivateSheet" on my sheets.

I have a button that do action "ActivateSheet" → the sheet's "OnActivateSheet" trigger is rightly triggered.

I have a ListBox on a field, and this field has a "Field Event Trigger" with "On Select" that do a "ActivateSheet" → the sheet's "OnActivateSheet" trigger is NOT triggered.

Is there a reason?

Re: Action "activate sheet" don't trigger "on activate"

Gysbert_Wassenaar — Fri, 26 Oct 2018 12:39:17 GMT

Afaik you can't use a trigger to get another trigger to fire. The solution is to add the actions of the second trigger to the first trigger.

Re: Action "activate sheet" don't trigger "on activate"

nicolas_martin — Fri, 26 Oct 2018 12:49:32 GMT

> The solution is to add the actions of the second trigger to the first trigger.

Usually, each sheet has it's own "default selection".

My list box do "go to the sheet corresponding to the selection".

I can't do "go to the sheet corresponding to the selection, if it's SH01 then do this, if it's SH02 do this, ...". I would be forced to use macros.

> Afaik you can't use a trigger to get another trigger to fire.

Yet, when it's triggered by a button object, it works.

Re: Action "activate sheet" don't trigger "on activate"

jerrysvensson — Fri, 26 Oct 2018 12:51:53 GMT

OnActiveSheet only works with Plugin, not in Ajax (WebView).

Re: Action "activate sheet" don't trigger "on activate"

Gysbert_Wassenaar — Fri, 26 Oct 2018 13:41:45 GMT

Let me rephrase that: Afaik you can't reliably use a trigger to get another trigger to fire, especially when both involve selections in fields.

Re: Action "activate sheet" don't trigger "on activate"

achettipalli — Fri, 26 Oct 2018 13:53:56 GMT

Hi Nicolas,

Interesting case.

As Gysbert suggestion you can add those triggers and use "Alternate states" for each sheet for default selections.

Good luck.

Avinash

Re: Action "activate sheet" don't trigger "on activate"

cwolf — Fri, 26 Oct 2018 15:06:43 GMT

because of cascading actions, you have to increase the parameter "MaxActionLevel" in the file "settings.ini" in section "Settings 7". If it does not exist, create a new entry. Default value is 1.

For example:

[Settings 7]

MaxActionLevel=2

For desktop users:

c:\Users\username\AppData\Roaming\QlikTech\QlikView\Settings.ini

On the server:

c:\ProgramData\QlikTech\QlikViewServer\Settings.ini

- Christian

Re: Action "activate sheet" don't trigger "on activate"

nicolas_martin — Mon, 29 Oct 2018 08:38:54 GMT

Thank you Christian!

It works as expected!

Re: Action "activate sheet" don't trigger "on activate"

nicolas_martin — Tue, 30 Oct 2018 10:20:21 GMT

It works for me.