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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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.