topic Re: On Open Reload in QlikView in QlikView

On Open Reload in QlikView

nancy_sbeity — Sat, 16 Nov 2024 04:32:03 GMT

Hello,

My Target is to reload my qlikview application On open.

I am using QlikView server. I have created a run macro script on open from the document settings. My code:

Sub ReloadOnOpen

ActiveDocument.Reload

End Sub

Then I have added this document to my source documents on the server, so each user will be able to access it from its own QlikView desktop. But the problem is that the reload code didnt work at the level of the user and even at the level of the server.

I tried all the suggestions on Community. Can anyone provide me with the right answer?

Thank you in advance

Best Regards,

Nancy Sbeity

Re: On Open Reload in QlikView

pradosh_thakur — Thu, 07 Feb 2019 08:39:38 GMT

It's not working when you open it with Qlikview application or Access point? Macros mayn't work on ajax.

Did you try the document level trigger of on open reload option?

Re: On Open Reload in QlikView

nancy_sbeity — Thu, 07 Feb 2019 08:45:50 GMT

Hello,

Actually I didnt get your point. but you can find attached the document I am trying to apply the macros on.

I have tried to open using QV desktop with no success.

Thanks for your help.

Re: On Open Reload in QlikView

pradosh_thakur — Thu, 07 Feb 2019 09:00:14 GMT

Try below

Re: On Open Reload in QlikView

pradosh_thakur — Thu, 07 Feb 2019 09:02:39 GMT

I guess QV12 doesn't have a reload button on document level reload trigger.

So you need to write ='ReloadOnOpen' in the macro name in the expression box and it will work , like i have showed in the screenshot above.

Re: On Open Reload in QlikView

nancy_sbeity — Thu, 07 Feb 2019 09:18:41 GMT

Good news! It worked at the level of the server. Now when a user is accessing it through Qlikview desktop (Open in Server). it won't work. Is there something missing?

Re: On Open Reload in QlikView

pradosh_thakur — Thu, 07 Feb 2019 09:24:59 GMT

have a look
https://community.qlik.com/t5/QlikView-App-Development/macros-not-working-on-server/td-p/309806

Re: On Open Reload in QlikView

pradosh_thakur — Thu, 07 Feb 2019 11:28:53 GMT

Hi

Is the query resolved or you are still stuck ?

Re: On Open Reload in QlikView

nancy_sbeity — Thu, 07 Feb 2019 14:30:09 GMT

Hello,

Actually no 😞

It worked at the level of the server only. but when a user try to access from qv desktop, nothing happens.

Re: On Open Reload in QlikView

pradosh_thakur — Thu, 07 Feb 2019 14:32:52 GMT

the same app ? Can you double check the macro name is as i have mentioned.

Check

User preference -> security -> macro related check are ticked
documnet properties -> security -> macro related check are ticked

There is no reason why it should not work.

Re: On Open Reload in QlikView

nancy_sbeity — Thu, 07 Feb 2019 14:45:14 GMT

Please find attached. I dont know what is missing.

Re: On Open Reload in QlikView

pradosh_thakur — Thu, 07 Feb 2019 14:53:14 GMT

It should work. Ask the user to ctrl+M and manually run the macro. Let's see if it works or not.

Re: On Open Reload in QlikView

nancy_sbeity — Fri, 08 Feb 2019 07:23:46 GMT

Hello,

Nothing happened when I clicked on ctrl+M!

Re: On Open Reload in QlikView

pradosh_thakur — Fri, 08 Feb 2019 08:20:00 GMT

ask the user to open the macro manually and run it. See if that works.

Re: On Open Reload in QlikView

nancy_sbeity — Fri, 08 Feb 2019 09:18:34 GMT

Hello,

User doesn't have the access to open the macro manually. Document properties is disabled. How can I allow the user to access the macro?

Re: On Open Reload in QlikView

pradosh_thakur — Fri, 08 Feb 2019 09:26:00 GMT

Have a look

https://community.qlik.com/t5/QlikView-Deployment/How-to-Enable-all-macros/td-p/1110158

Re: On Open Reload in QlikView

nancy_sbeity — Fri, 08 Feb 2019 11:08:20 GMT

No good news!

Is it because of the user have Qlikview12?

I have applied every single thing.

Re: On Open Reload in QlikView

pradosh_thakur — Fri, 08 Feb 2019 11:13:33 GMT

no.. macro works on qlikview 12. You may need to check your user preference and document settings. reload it as an admin . make sure the macro override security are checked .

Re: On Open Reload in QlikView

nancy_sbeity — Fri, 08 Feb 2019 11:22:37 GMT

Document Settings: Macro override security is checked.

User preferences: Confirm Launch from Macro is checked.

Macros two checkboxes on the server also checked.

What else?

And thx for your continuous support

Re: On Open Reload in QlikView

pradosh_thakur — Fri, 08 Feb 2019 11:27:43 GMT

It should work. Let me tag @marcus_sommer . He might know why this is happening and help you out.