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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

OnOpen is not triggered

Hello

I got a qlikview document in which I'm executing a macro which logs the username and the date and time the user is opening the document

this macro is being called on the onOpen trigger or event

the macro is being called and runs sucessfully if the document is opened from QlikView Client or Google Chrome

However if the user opens the document using Internet Explorer the event OnOpen is not triggered at all

is there a work-around for this issue?

Please advise

I can walk on water when it freezes
3 Replies
Not applicable

Hello,

I tried the Google Chrome, it is not working too.

May be a mandatory button should be created on the first screen.

Not applicable

This function has never worked for me either. I always figured it actually meant OnOpen of the file itself, rather than on the session/instance as from the user's perspective. Hence why it didn't work when users clicked on the file. But if you say it works in Chrome then maybe it is just some problem with IE.

If your tab in the file is just an intro/welcome page then you could set the macro to trigger when the user leaves the sheet.

ToniKautto
Employee
Employee

In order to conclude if it is the macro itself or the trigger that does not work, please trigger exactly the same macro code from a button. If the macro does not execute from the button, then it is very likley that the macro itself is not executable from the webclient.

For IE Plugin it can be related to security settings not allowing execution. Please make sure the security settings allow this, not only in the actual QVW but also on the client machine.

1. Open a QlikView document in IE Plugin

2. Press Ctrl+Shift+M

3. Set the suitable security setting

Depending on the macro code, it might not be something that even should be executable on a server environment. Please check the reference manula section about "Using Macros in QV Documents on the QV-Server", section 82 and page 889 in QlikView 11 manual.