Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Auto reload on open

How to make a Qlikview 10 file auto reload on open?

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

Hi,

Go to the Settings menu, Document Properties, Triggers tab, OnOpen and add a new action type External, Run Macro. Click on the "Edit Module..." button and use the following piece of code:

Sub ReloadOnOpen

     ActiveDocument.Reload

End Sub

Click OK and set the name of the macro to ReloadOnOpen.

If you are using QlikView 11 it does have an action to Reload, use it instead of the macro code above. Note that this code might not work in a server environment.

Hope that helps.

Miguel

View solution in original post

3 Replies
Miguel_Angel_Baeyens

Hi,

Go to the Settings menu, Document Properties, Triggers tab, OnOpen and add a new action type External, Run Macro. Click on the "Edit Module..." button and use the following piece of code:

Sub ReloadOnOpen

     ActiveDocument.Reload

End Sub

Click OK and set the name of the macro to ReloadOnOpen.

If you are using QlikView 11 it does have an action to Reload, use it instead of the macro code above. Note that this code might not work in a server environment.

Hope that helps.

Miguel

Not applicable
Author

It works. Thanks a lot!

bvssudhakar
Creator III
Creator III

Hi Miguel,

If i want to reload the document in closed time also what should i modify, Can you suggest me??

Thank you in advance