On Open Reload in QlikView

[nancy_sbeity]

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

[pradosh_thakur]

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?

[nancy_sbeity]

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.

[pradosh_thakur]

Try below

[pradosh_thakur]

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.

[nancy_sbeity]

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?

[pradosh_thakur]

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

[pradosh_thakur]

Hi

Is the query resolved or you are still stuck ?

[nancy_sbeity]

Hello,

Actually no 😞

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

[pradosh_thakur]

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.