Qlikview External Automator

Mon, 03 Aug 2009 22:22:54 GMT

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

Qlikview External Automator

Anonymous — Fri, 24 Sep 2010 17:12:14 GMT

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.

topic Qlikview External Automator in QlikView

Qlikview External Automator

Qlikview External Automator