Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

luke1986
New Contributor III

Force close Script Execution Progress window after reload

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

1 Solution

Accepted Solutions
vinieme12
Esteemed Contributor II

Re: Force close Script Execution Progress window after reload

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

4 Replies
vinieme12
Esteemed Contributor II

Re: Force close Script Execution Progress window after reload

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

Highlighted
luke1986
New Contributor III

Re: Force close Script Execution Progress window after reload

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
Esteemed Contributor II

Re: Force close Script Execution Progress window after reload

sorry forgot to mention,

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

Yes, just replace the file name

luke1986
New Contributor III

Re: Force close Script Execution Progress window after reload

Thanks!

Community Browser