Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

A question regarding Sheet Event Triggers.

Hi,

A question regarding Sheet Event Triggers.

1.

I notice that I can run a macro 'Sub Reload ActiveDocument.Reload End Sub' with a trigger.

OnActivateSheet - Add Action - Add - External - Run Macro - Reload.

That works fine the document reloads when I open the sheet.

2.

However when I use the predefined action reload nothing happens.

OnActivateSheet - Add Action - Add - External - Reload (option in action list).

Why does the under 2 mentioned scenario not work?

What is it that I have done wrong?

Thanks in advance,

Gerrit

7 Replies
giakoum
Partner - Master II
Partner - Master II

looks like it is working for me:

Capture.PNG

Not applicable
Author

The scenario in your reply is scenario 1, that works fine.

What is not working is scenario 2 (see image)

notworking.gif

giakoum
Partner - Master II
Partner - Master II

Sorry, wasn't paying enough attention.

Are you trying this in the desktop or through the access point?

In the desktop it should work as expected, but it will not work in the access point. There you need a publisher EDX task, which is a bit complicated. See attached file.

Not applicable
Author

I use the Windows Desktop Client.

notworking.gif

And it just doesn't work

giakoum
Partner - Master II
Partner - Master II

my version is 11.0 SR2.

and it works as expected. Could you please check your version?

Capture.PNG

update : adding file

Not applicable
Author

My version is 11.0 SR1.

notworking.gif

It is not a button trigger but the 'Sheet Event Trigger - Add Action - Actions - Reload' that is not working (see image).

giakoum
Partner - Master II
Partner - Master II

yes quite right it is not.

I am not sure if this is a bug or a feature, as reloading every time you activate a sheet might not be a good idea. Cannot help further I am afraid.