Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Execute macro after reloading through scheduler

Hello All,

I have scheduled my report through scheduler and now I want to execute the macro without opening the document.

Need help on this urgently.

6 Replies
kaushalview
Partner - Creator II
Partner - Creator II

Hi,apurva

Fisrt u write macro then do below steps.

Go Document Porperty--->Select On Post Reload---> Click on button Add Action on RightSide---->then one window is open----> Cllick on Add button----->Select External Option---->Run Macro

  Regards

Kaushal Mehta

Not applicable
Author

I have already done this.

when I open the report and click on Reload button, then once reloading is completed it will execute the macro.

But when the same report is reloaded through qlikview server using scheduler, same macro is not getting executed.

So how to execute the same macro when reloadin report through scheduler.

Not applicable
Author

Hi,

      Just  create a macro as a seperate file and then call it from the batch file after the execution of scheduled reload task.

     It will work.

     Let me know if you have any doubts.

Regards

Rajan

Not applicable
Author

Hi Rajan,

What type of file are you saying to create?

Please can you explain me in more detail please?

Not applicable
Author

Please can any one put some light on this issue?

Not applicable
Author

Hello All,

I did used windows batch file to execute the macro.

So the issue is resolved now..

Thanks to everyone for helping