Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Run Macro after reload in QV Server

Hi, I have macro to export straight table to excel.

I've testing manual to run that macro and it's successful  create excel file.

I need that file excel daily, so how to run automatically macro after qvd files succeed reload in QVS

3 Replies
Siva_Sankar
Master II
Master II

Hi Yislam,

Setting-->Document Property-->Trigger-->Select On Post Reload-->Click on Add Button on right side

then add Action as Run Macro --> MacroName.

In server, sometimesOnPostReload event is not fired after a server reload. You will need to use a batch load using QV desktop to perform the reload.


-Siva

Anonymous
Not applicable
Author

Hi Siva,

You mean I must reload again using a batch? Can you give me another option

Btw syntax to reload like this below:

"C:\Program Files\QlikView\Qv.exe" /r "E:\Data\Small_test.qvw"

marcus_sommer

A reload from the qmc is executed from the qvb.exe which don't execute any macros because it updates just the data and didn't load the UI features. The meant you will need some kind of batch-execution but you could trigger them through the qmc with an EXECUTE statement - here one example as a starting point: Re: How can I run a macro on QMC after reload?

- Marcus