topic Run Macro after reload in QV Server in QlikView

Run Macro after reload in QV Server

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Run Macro after reload in QV Server

Siva_Sankar — Thu, 05 Apr 2018 02:30:47 GMT

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

Re: Run Macro after reload in QV Server

Anonymous — Thu, 05 Apr 2018 06:25:46 GMT

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"

Re: Run Macro after reload in QV Server

marcus_sommer — Thu, 05 Apr 2018 08:19:59 GMT

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