topic Re: How to Export object to Excel using Macro from QMC in QlikView

How to Export object to Excel using Macro from QMC

infosense_devel — Wed, 22 Nov 2017 13:12:27 GMT

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.

Re: How to Export object to Excel using Macro from QMC

petter — Wed, 22 Nov 2017 13:20:38 GMT

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.

Re: How to Export object to Excel using Macro from QMC

petter — Wed, 22 Nov 2017 13:23:06 GMT

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

Starting QlikView ‒ QlikView

Re: How to Export object to Excel using Macro from QMC

Yang_Jiao — Mon, 21 May 2018 11:36:17 GMT

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.