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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to call self module via external script (QlickView Automation)

Hi all,

I try call self module in my Document(.qvw) via PowerShell.

Currently this module named "sei_exp_tsv", and saved in my QlickView document.

This module call from "Run macro" action. I want to automate this action.

But I don't know how to call this module...

** module: sei_exp_tsv

sub sei_exp_tsv

tmpPath = ActiveDocument.GetPathName

lastBackSlash = InStrRev( tmpPath , "\" )

vPath = Left( tmpPath , (lastBackSlash - 1) )

vFileName = "sei_data.tsv"

set Obj = ActiveDocument.GetSheetObject("CH14")

obj.Export vPath & "\Export\" & vFileName," "

end sub

** end module

** PowerShell (v4.0)

$Qv = New-Object -ComObject "QlikTech.QlikView"

$QvDoc = $Qv.OpenDoc("C:\QlikView\QvWork\test.qvw")

# I don't know how to call module

# Cann't work bellow

# $QvDoc.Run("sei_exp_tsv")

** end PowerShell

Please give your idea.

Thanks

Naoki

0 Replies