topic OnOpen is not triggered in QlikView

OnOpen is not triggered

ali_hijazi — Sat, 24 Mar 2012 17:48:53 GMT

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

OnOpen is not triggered

Mon, 26 Mar 2012 06:39:59 GMT

Hello,

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

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

OnOpen is not triggered

Mon, 26 Mar 2012 09:00:01 GMT

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.

Re: OnOpen is not triggered

ToniKautto — Mon, 26 Mar 2012 12:13:13 GMT

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.