topic VBScript code to reload a document QlikView in QlikView

VBScript code to reload a document QlikView

Tue, 10 May 2011 09:21:53 GMT

Hi community.

Please can someone help me to write a VB script to relaod a qlikview document.

I want that when a user press on a button, the QlikView document is charging by running this code VBSCRIPT.

Thanks

VBScript code to reload a document QlikView

Tue, 10 May 2011 09:30:48 GMT

Hello I am not sure for VB, but heres what you can use in the comman line or for a batch file and just do some research around this :

"C:\Program Files\QlikView\Qv.exe" /r "C:\Documents and Settings\User\Desktop\QvApps\MyConnection.qvw"

This above command works as a batch file and the /r takes care of opening and reloading the Qlikview file...

Hope this helps.

Mady

VBScript code to reload a document QlikView

Tue, 10 May 2011 09:36:34 GMT

Thks for ur response Mady.

But i want a vbscript.

thx.

VBScript code to reload a document QlikView

Tue, 10 May 2011 09:42:47 GMT

write this in Macro editor

sub myreloadfunction

ActiveDocument.Reload

end sub

this will reload the current document or Active Document or that document where it is written.

Regards,

Shubhu

VBScript code to reload a document QlikView

Tue, 10 May 2011 09:45:57 GMT

Thx SHUBBU, it's OK

Re: VBScript code to reload a document QlikView

rbecher — Tue, 10 May 2011 10:02:21 GMT

In some situations the reload popup window shows no progression. Therefor we're using this way:

set shell = CreateObject("WScript.Shell")

shell.AppActivate ActiveDocument.GetApplication.GetProcessId

shell.SendKeys "^r"

It is sending the hotkey Ctrl+R to the QV menu. You could also use this for other use cases (e.g. a save button).

- Ralf

Re: VBScript code to reload a document QlikView

Thu, 27 Oct 2011 14:40:39 GMT

I need to refresh a QV document every 5 minutes with new data since the last reload. I don't want the user to have to click a button, I just want the latest data always available. What would be the best way to this?

VBScript code to reload a document QlikView

Thu, 27 Oct 2011 15:20:35 GMT

Hi Jammie,
you go to Scheduled Tasks in MS Windows, fire up there every five minutes test.cmd this batch with an ending. cmd Example

Contents of the batch:
"C: \ Program Files \ QlikView \ QV.exe" / nosecurity / r "Q: \ real \ Departments \ IT \ test.qvw"

test is your QV

by Armin