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

[#1]

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

[vgutkovsky · Accepted solution]

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?

[#3]

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

[vgutkovsky]

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

Regards,