topic Reload two documents using macros in QlikView

Reload two documents using macros

Wed, 24 Feb 2010 18:40:25 GMT

I've two qvws... Extraction (load data from excels files and oracle) and Presentation (load data from Extraction's qvds).
In Presentation, I add a button with a macro to reload Extraction and Presentation:

SUB ReloadDocuments
'Reload Extraction
set App = ActiveDocument.GetApplication
Set Doc = App.OpenDoc("Extraction.qvw")
Doc.Reload
Doc.Save
Doc.CloseDoc

'Reload Presentation
ActiveDocument.Reload

END SUB

it's works in my Qlikview 9 Desktop; but when I upload to the server I get a message "Failed to open document".

Any ideas? Another way to resolve this without macros? Thanks!

Reload two documents using macros

rwunderlich — Thu, 25 Feb 2010 01:29:26 GMT

You can't use the OpenDoc or Reload API calls in the server environment. To trigger a reload, set up an EDX task and have your button hit a URL that triggers the EDX task. The specifics vary be version. What version of QVS are you running?

-Rob

Reload two documents using macros

Thu, 25 Feb 2010 12:38:52 GMT

I'm using QV9. I don't know about EDX task... I go to google it...

Reload two documents using macros

Sun, 13 Mar 2011 03:48:44 GMT

HI, sebagiar

Is your problem sovled? I have the same question.