Run qlikview application via PowerShell (using Task Scheduler)

asgardd2 — Wed, 27 Jul 2016 12:25:17 GMT

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.

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

flanfranco — Wed, 27 Jul 2016 17:38:06 GMT

Hi, see this post:

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