topic Refresh the data on opening the QlikView File in QlikView

Refresh the data on opening the QlikView File

Wed, 25 May 2011 03:47:26 GMT

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

Refresh the data on opening the QlikView File

Wed, 25 May 2011 08:30:46 GMT

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

Refresh the data on opening the QlikView File

Fri, 17 Jun 2011 14:10:09 GMT

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