topic Re: OnActivate Sheet Trigger - External Function not working in QlikView

OnActivate Sheet Trigger - External Function not working

Mon, 26 Jan 2026 18:19:17 GMT

Sheet Properities -> OnActivate Sheet -> External action

Do not seem to operate when the sheet is activated. Simple Externals in use are as "Open URL" or "Run Macro". These functions work fine when associated with objects such as a button.

Note the sheet these actions are associated with is not the primary sheet in which the document opens into from our AccessPoint server.

TIA

Stoney

Re: OnActivate Sheet Trigger - External Function not working

Thu, 08 Nov 2012 18:05:58 GMT

Hi, Stoney.

I´m having a similar problem. Whe are trying to get rid of macros specially of the one we use in the menu.

A field contains the names of the dashboards while another one has sheets ids - they have a one-to-one relationship. When I click on a list with the dashboard name field, a "On select" document trigger activates the sheet (using the sheet code field). It does work perfectly, but it also deactivates the "On Activate Sheet" triggers of the activated sheet.

I figured out this action works when I use a button or a text object. Maybe it happens because they have their own triggers and don´t require document triggers.

Any ideas?

Gabriela

Re: OnActivate Sheet Trigger - External Function not working

Fri, 03 Oct 2014 23:27:46 GMT

Was there any resolution on this? I am having the same problem.

Re: OnActivate Sheet Trigger - External Function not working

Anonymous — Sat, 04 Oct 2014 09:52:41 GMT

Are you using the ajax client ?

As many triggers including <OnActivate Sheet> do not work in ajax mode.

Re: OnActivate Sheet Trigger - External Function not working

ashfaq_haseeb — Sun, 05 Oct 2014 12:56:34 GMT

HI,

You can use text boxes as sheet and add actions to this.

As many of them (Actions) does not works in on open sheet trigger.

Let me know if that worked.

Regards

ASHFAQ

Re: OnActivate Sheet Trigger - External Function not working

Wed, 08 Oct 2014 17:42:18 GMT

Yes, we are using AccessPoint, so <OnActivate Sheet> does not work. I can get a button to load the other document, but it isn't an ideal solution. Thanks.