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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview External Automator

Hi,

I'm having issues running a VBS script from the commandline which reloads a .qvw file. I need it to leave the current window alone and open a "background" thread version of QV.exe. Does anyone know how to do this?

Here's a sample of the code I'm using in my .vbs file:


Option Explicit
Dim qlikapp
Dim qlikdoc

Set qlikapp = CreateObject("QlikTech.QlikView")
Set qlikdoc = qlikapp.OpenDocEx("Y:\BI\DEV Space\DailyPLSO.qvw", 0, False)

qlikdoc.ReloadEx 2,1 ' 2=ignore Errors; 1=hide process dialog
qlikdoc.save
qlikdoc.CloseDoc

'qlikapp.Quit

Set qlikapp = Nothing
set qlikdoc = Nothing


I've even tried a method of calling it from an AccessDB using vba:


Private Sub RefreshQVW_Click()
Dim App As New QlikView.Application
Dim Doc As QlikView.Document

Set Doc = App.OpenDocex("Y:\BI\DailyPLSO.qvw", 0, False, "", "", "", False)
With Doc
.ReloadEx 2, 1
.Save
.CloseDoc
End With
Set App = Nothing
Set Doc = Nothing

End Sub


1 Reply
Anonymous
Not applicable
Author

Hi Michael,

Have you found a solution to your problem ?
I've got the same issue trying to create a stress test vbscript for QlikView.

Best Regards
Stéphane.