Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
matteofioroni
Contributor

Automatic Reload and macro execution

I'm in troubles with macros!

I've setted up a qlikview application (very simple).

I've triggered a macro script after reload.

If I reload the application all works fine and the macro is excuted.

Now I need to automate the reload and macro execution, so I've writed a .bat file that reload the document (with /r and /nosecurity options). When I lunch the .bat file the document seems to be reloaded but the execution stall at the macro point (the sheel prompt seems to be inactive after reload).

I've also tried with publisher, but doesn't work...

The macro I use simply send a mail.

How can I automate the reloading and macro executing processes?

Thank You in advance for your help.

Matteo

2 Replies
Not applicable

Automatic Reload and macro execution

Hi,

I have faced the same situation like this. When you reload the application, it sends the mail but when you automate the application through schedulers, it will just reload the application but will not execute the Macro.

Use a variable in your batch file and use that in the macro execution.

"c:\Program Files\QlikView\QV.exe" /r /vbatch_flag=1 c:\reports\Inventory.qvw

First time just reload the application and set the variable in the macro that if the value satisfies, then and only it will send the mail.

Second time Use the above script that will send the variable value.

IMP Run the Macro on the Opening of the Secong time Application.

Not applicable

Automatic Reload and macro execution

HI ,

try using below script.

"C:\Program Files\QlikView\qv.exe" /r "E:\Daily QVD & Appl\Apps Daily QVD Generator.qvw"

Community Browser