topic Re: Open QVW using automation? in QlikView

Open QVW using automation?

punitpopli — Tue, 20 Feb 2018 03:25:29 GMT

Hi Experts,

I am having a requirement where i need to open the application (QVW) automatically on the daily basis.

Can we do this using Macro but not using task scheduler?

For e.g

A.qvw need to be open on the daily basis (in the morning) and close in the evening automatically.

Regards,

Punit

Re: Open QVW using automation?

vishsaggi — Tue, 20 Feb 2018 06:01:53 GMT

Can you elaborate? You want to open this QVW on your desktop? Why don't you write a Task scheduler and schedule a task to open and close the documents creating a batch file to open and close.

Re: Open QVW using automation?

punitpopli — Tue, 20 Feb 2018 06:30:29 GMT

Yes, I want to open this on desktop, as few scripts run in the app which copy the data from Sharepoints

I have found a way using batch file running in loop for every 40 mins

:loop

"C:\Program Files\QlikView\Qv.exe" /r "FilePath\FileName.qvw"

TIMEOUT 2400

goto loop

Re: Open QVW using automation?

vishsaggi — Tue, 20 Feb 2018 06:38:43 GMT

Ok just use this batch file to run from your task scheduler.