topic Re: Force close Script Execution Progress window after reload in QlikView

Force close Script Execution Progress window after reload

luke1986 — Thu, 01 Jun 2017 08:29:03 GMT

Hello,

We have an application which the server reloads with a batch as soon as a trigger execute it.

(qv.exe /R C:\Qlikview\blabla.qvw)

This works fine as long as the Option: "close Script Execution Progress window after reload" is ticked off.

Strangely, this Option seems to reset quite often and the batch then fails or run in a loop.

Is there an a way to force close this window no matter what? Maybe with vbs or Macro?

Thanks Lukas

vinieme12 — Thu, 01 Jun 2017 08:38:35 GMT

try like below

Check reference Qlikview XX.xx type library

sub reloadqvw()

Dim App As New QlikView.Application

Dim Doc As New QlikView.Document

Set Doc = App.OpenDoc(<<Filename.QVW>>, "", "")

Doc.Activate

Doc.ReloadEx 0, 0

Doc.Save

Doc.CloseDoc

End Sub

luke1986 — Thu, 01 Jun 2017 09:51:20 GMT

Hello Vineeth,

Do i have to run this in the Qlikview Macro Editor or outside as a vbs script?

Replacing the Filename.qvw with the name of the application, is that all or do i need to do something else?

Lukas

vinieme12 — Thu, 01 Jun 2017 12:30:32 GMT

sorry forgot to mention,

Out side of Qlikview, i have this in an excel workbook

Yes, just replace the file name

luke1986 — Thu, 01 Jun 2017 13:39:08 GMT

Thanks!