topic Re: Macro issue in QlikView

Macro issue

Tue, 10 Dec 2013 06:16:59 GMT

Hi all,

I have a macro which is used to save report to pdf document on

the server machine. It is excuted after reloading (Document Event Trigger > OnPostReload) with success. New pdf document was created on the server machine after i run it on the machine. But when i put this qvw file to document folder of this QlikView Server and run it on QMC. No pdf document is added to the server machine.

What's the problem? Please help me. Thanks in advance.

Zhou

Re: Macro issue

jerrysvensson — Tue, 10 Dec 2013 07:34:48 GMT

OnPostReload (no Triggers will run) will not run when you run it in QMC. See Reference manual.

You can either setup an External task or a Windows task and use:

qv.exe /r app.qvw to get your save report to pdf to work.

Re: Macro issue

Tue, 10 Dec 2013 08:38:35 GMT

Thanks Jerry, I think you're right. Macro won't be excuted after reloading task.

When i tried windows task and the .bat file is like this :

qv.exe /r [my app.qvw]

But It didn't start to reload. Meanwhile, how can i do it using External task?

thanks

Re: Macro issue

jerrysvensson — Tue, 10 Dec 2013 09:28:52 GMT

You have to use:

"c:\program files\qlikview\qv.exe" /r "c:\temp\My app.qvw"

Your path to qv.exe might be different.

You can use the exact same syntax in External task.

Re: Macro issue

Tue, 10 Dec 2013 09:41:04 GMT

Thank you, Jerry. It worked using .bat file ! But i don't get your External task. I nerver use it. Do you mean the "On a External Event" when setting reload schedual in QMC (and what the password mean)? Thanks!

Re: Macro issue

jerrysvensson — Tue, 10 Dec 2013 09:56:07 GMT

No that is an event.

If you have Publisher. Go to System, choose Supporting tasks, click the + and you will find External program.

Basically the same as using Windows Task scheduler.

Re: Macro issue

Tue, 10 Dec 2013 10:04:06 GMT

My issue come with my having no Publisher...Thanks anyway. I choose to use Windows task.