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

[nicolas_martin]

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?

[Gysbert_Wassenaar]

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.

[nicolas_martin]

> 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.

[jerrysvensson]

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

[Gysbert_Wassenaar]

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.

[achettipalli]

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

[cwolf · Accepted solution]

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

[nicolas_martin]

Thank you Christian!

It works as expected!

[nicolas_martin]

It works for me.