topic Re: auto reload on desktop version in QlikView

auto reload on desktop version

Anonymous — Wed, 17 Jul 2013 10:55:13 GMT

Dear all,

I tried the autoreload (by a windows task) and it works. The problem is that the system opens a new istance of Qlikview for each reload.

I need to reload any 5 minutes, so after 10 minutes I've two active instances of the document.

What can I do to solve it ?

Thanks in advance

Re: auto reload on desktop version

luciancotea — Wed, 17 Jul 2013 11:02:36 GMT

Create a RunAndClose.vbs file and run it:

Set MyApp = CreateObject("QlikTech.QlikView")
Set MyDoc = MyApp.OpenDoc ("C:\QlikView\MyApp.qvw","","")
Set ActiveDocument = MyDoc
ActiveDocument.Reload
 
MyDoc.GetApplication.Quit
Set MyDoc = Nothing
Set MyApp = Nothing

Re: auto reload on desktop version

Anonymous — Wed, 17 Jul 2013 11:10:39 GMT

Hi Lucian,

thanks for your answer.

Just one thing: how can I create a vbs file ? I'm sorry, but I never used them.

Thanks in advance

Re: auto reload on desktop version

luciancotea — Wed, 17 Jul 2013 11:12:23 GMT

Create a text (.txt) file in Notepad, then change the extension to .vbs

Re: auto reload on desktop version

Anonymous — Wed, 17 Jul 2013 11:18:32 GMT

Thanks!!

If I understood (but I'm not sure) the script, it opens my document and close it.

What I'm trying to do is that , after the first time, when I launch again the reload process, I should kill the previous instance if is activem in order to have only one open document.

Is it possible to do ?

Re: auto reload on desktop version

luciancotea — Wed, 17 Jul 2013 11:30:04 GMT

Then why don't you reload from macro every 10 min without closing the document?

Use Now () function to calculate if more than 10 minutes passed from last reload.

Re: auto reload on desktop version

Anonymous — Wed, 17 Jul 2013 11:35:27 GMT

Because I don't know how to use macro...

Re: auto reload on desktop version

luciancotea — Wed, 17 Jul 2013 11:44:52 GMT

Press CTRL+M to show the Macro window. Paste this:

Sub ReloadDoc

ActiveDocument.Reload

ActiveDocument.Save

End sub

This macro will reload and save your doc every time you call it.