Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello,
I tried the Google Chrome, it is not working too.
May be a mandatory button should be created on the first screen.
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.
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.