topic Re: Call Macro from Load Script in QlikView

Call Macro from Load Script

avastani — Fri, 03 Aug 2012 14:02:58 GMT

Hi,

I have a macro that receives the values from variables set in the load script. Is there a way to call that macro from the load script?

I tried

LET a = myMacroCall();

and also tried

Table:

LOAD myMacroCall() as A

AUTOGENERATE(1);

neither seemed to work.

The macro receives the variables, passes it to in soap request and then stores the response into a temp XML file that is then reloaded into the app and finally calls another macro to remove the temp XML file.

Function myMacroCall

Set fromDate = ActiveDocument.Variables("vFromDate")

Set toDate = ActiveDocument.Variables("vToDate")

... do processing

.. output to XML file

End Function

Re: Call Macro from Load Script

Fri, 03 Aug 2012 14:13:22 GMT

Maybe youd could try to use the OnPostReload trigger.

Re: Call Macro from Load Script

avastani — Fri, 03 Aug 2012 14:26:11 GMT

OnPostReload cannot run from Publisher I believe

Re: Call Macro from Load Script

Fri, 03 Aug 2012 14:32:56 GMT

Maybe should check this topic:

http://community.qlik.com/thread/12166

Re: Call Macro from Load Script

avastani — Fri, 03 Aug 2012 14:53:58 GMT

that is a very simple example, if i add variables to it, it doesn't work