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!
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?
