How to Export object to Excel using Macro from QMC

[infosense_devel]

Hello All,

I have facing issue to export chart object to excel with Macro from QMC.

I have tried in my local system, it's successfully run on Post Reload of QVW, but when I do same from QMC, it's not exporting that excel file as well as in log file there is no error related to Macro.

Is there any other way to get direct excel export of chart object in qlik view from QMC?

Thanks.

[petter]

The "Post Reload" event will not be triggered in a normal task run from the QMC. The reason is that the batch reload engine of QlikView Server or QlikView Publisher does not have support for Macros (VBScript/JScript) at all.

To be able to achieve what you want you will have to have a scheduler to execute the QV.EXE file with some commandline parameters so the Desktop Reload Engine is generating the Excel file via a macro. This is not a very robust solution but it does work.

[petter]

The QV.EXE command line syntax you can find here:

Starting QlikView ‒ QlikView

[Yang_Jiao]

Think you can refer to https://community.qlik.com/docs/DOC-6060 or https://qliktech.hosted.jivesoftware.com/thread/73539 as well, if you still haven't found the solution.