topic Re: Sub in a macro in QlikView

Sub in a macro

Wed, 18 Dec 2013 11:30:50 GMT

Hi, i Have a Sub in a Macro and i want to execute them as i reload my application.

well, i was searching and found the comand "call", i tried it but it's not working. I think that is cause is in a macro.

someone can help me?

Thank you.

Re: Sub in a macro

luciancotea — Wed, 18 Dec 2013 11:32:57 GMT

Call VBA macro function from the load script | Lucian Cotea

Re: Sub in a macro

tresB — Wed, 18 Dec 2013 11:41:03 GMT

If your macro returns a value, you can call that in the script like:

Let vGetFromMacro = YourMacroName();

Remember, you can't access UI object from script.

Re: Sub in a macro

Wed, 18 Dec 2013 11:47:54 GMT

in my case, my sub don't return anything, but thank you

i have a sub that do a report and send a e-mail to some people. I have the sub script, but it's not working yet

Re: Sub in a macro

sivarajs — Wed, 18 Dec 2013 11:48:48 GMT

Guess you cant directly call sub in qlikview script. You can define sub in function then you can call like above method

Re: Sub in a macro

Peter_Cammaert — Wed, 18 Dec 2013 12:58:05 GMT

Why not use a Document trigger called OnPostReload (see Settings->Document Properties->Triggers->Document Event Triggers)? That trigger will fire immediately after you do a document reload every time.

If you attach an action to this trigger like External->Run Macro and point that action to the macro Sub you already created, you get a more reliable result. Even works in a QVS environment.

See if that fits your requirements.

Best,

Peter

Re: Sub in a macro

luciancotea — Wed, 18 Dec 2013 17:09:11 GMT

Peter, OnPostReload does not work in QVS.

The following triggers are not to be used in the QlikView Server environment, since they lack meaning or may cause unexpected results:

OnPostReduceData

OnPostReload

"QlikView reference manual"

Re: Sub in a macro

Peter_Cammaert — Thu, 19 Dec 2013 08:16:48 GMT

Oh great. Probably been working on OCX models for too long. And even there, triggers don't always work reliably it seems.

Thanks for the reminder.

Peter