Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Reload two documents using macros

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!



3 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Not applicable
Author

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

Not applicable
Author

HI, sebagiar

Is your problem sovled? I have the same question.