Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

asgardd2
Contributor III

Run qlikview application via PowerShell (using Task Scheduler)

Hello!

     I have a problem with successful execution of task  in Task Scheduler (Windows Server 2012).

There are no problems, If i start it with option "Run only when user is logged on"

But if try change it to "Run whether user is logged on or not", my qlikview application is not starting correctly(if user is really log off):

How can I fix it?

The task is starting powershell script, which starts the QliKView application:

Start "C:\Program Files\QlikView\qv.exe"  "/NoSecurity C:\test.qvw"

In this QV app. i create OnOpen event trigger, which runs qlikview macro. (save to excel using function ExportToExcel)

sub ExportToExcel(ObjectId, FilePath)

    dim FileName

    Set FileName = ActiveDocument.GetSheetObject(ObjectId)

    FileName.ExportBiff FilePath

    Set FileName = nothing

end sub

Best Regards,

Aleksandrov Anton.

1 Solution

Accepted Solutions
Partner
Partner

Re: Run qlikview application via PowerShell (using Task Scheduler)

Hi, see this post:

"QlikView Desktop needs an UI and that is incompatible with batch execution (e.g. execution in the background without UI)"

View solution in original post

1 Reply
Partner
Partner

Re: Run qlikview application via PowerShell (using Task Scheduler)

Hi, see this post:

"QlikView Desktop needs an UI and that is incompatible with batch execution (e.g. execution in the background without UI)"

View solution in original post