topic Is there any possibility to call a Macro in the ‘Edit Script’? in QlikView

Is there any possibility to call a Macro in the ‘Edit Script’?

Fri, 27 Aug 2010 05:17:58 GMT

I have an application which uses some Macros to export sheet objects into Qvds when OnPostReload… In the charts(Straight Tables) I have used some set analysis expressions and need to export these values into qvds… As I know set analysis expressions cannot be done in the script.. (Or is there any possibility?)

When I deploy the application in qlikview server and use scheduled reloads, macros not working properly…

Therefore I wanted to know that is there any possibility to call the macros in the script?

Please help me on this issue

Thanks and regards

Nilupa

Is there any possibility to call a Macro in the ‘Edit Script’?

vgutkovsky — Fri, 27 Aug 2010 06:09:13 GMT

Nilupa,

Yes, you can use macros in the script. The syntax for that would be something like:


Sub macroname ()
 insert code here....
End sub
Call macroname()

Note there are no semicolons here.

But I'm not sure this would be appropriate in your case. How can you export sheet objects before the document finishes reloading?

Is there any possibility to call a Macro in the ‘Edit Script’?

Fri, 27 Aug 2010 06:25:07 GMT

Hi Vlad,

Thanks for your reply... Yes, it seems I can't do like that as you have mentioned...

Do you have any idea how can i achieve this..?

Thanks,

Nilupa

Is there any possibility to call a Macro in the ‘Edit Script’?

vgutkovsky — Fri, 27 Aug 2010 06:44:10 GMT

Take a look at Rob's post here, you may find it helpful: http://community.qlik.com/forums/t/17331.aspx

Regards,