Refresh the data on opening the QlikView File

[#1]

Hi All,

I have a Qlikview application dashboard that needs to show the data for only the last 6 weeks. I have created all the queries based of system date. The only thing I want to do is whenever an user opens the application the data should reload automatically. How do I do that?

Regards

Suresh

[#2]

Hi,

It is easy. You have to create a macro and launch it when opening the document.

Go to Tools --> Edit Module, and there add the following code:

Sub ReloadStuff

ActiveDocument.Reload

End Sub

After that, open Settings --> Document Properties, and go to Triggers tab. Select in Document Event Triggers "On Open" and add the External Action "Run Macro", using as Macro Name ReloadStuff.

This should work

[#3]

Hi,

your solution only works outside of the server. I marked both parameters "Allow macro execution on server" and "allow unsafe macro execution on server" on the Security Tab of the QlikView Server Settings. When I open the document in the AccessPoint, the macro is not executed nor is the file reloaded.

Is this a feature by design. Is there no way to dynamic reload a file on the server while accessing them through the AccessPoint?

Thanks in advanced,

Danny