Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Partner
Partner

On Open Reload in QlikView

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

 

 

Labels (3)
25 Replies
pradosh_thakur
Honored Contributor II

Re: On Open Reload in QlikView

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?
Learning never stops.
Partner
Partner

Re: On Open Reload in QlikView

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
Honored Contributor II

Re: On Open Reload in QlikView

Try below

 

1.JPG2.JPG

Learning never stops.
pradosh_thakur
Honored Contributor II

Re: On Open Reload in QlikView

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.
Learning never stops.
Partner
Partner

Re: On Open Reload in QlikView

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
Honored Contributor II

Re: On Open Reload in QlikView

pradosh_thakur
Honored Contributor II

Re: On Open Reload in QlikView

Hi

Is the query resolved or you are still stuck ?
Learning never stops.
Partner
Partner

Re: On Open Reload in QlikView

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
Honored Contributor II

Re: On Open Reload in QlikView

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.
Learning never stops.