Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
asgardd2
Creator III
Creator 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
flanfranco
Partner - Contributor III
Partner - Contributor III

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
flanfranco
Partner - Contributor III
Partner - Contributor III

Hi, see this post:

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