Script execution not working in Access point

[ksasidhars]

Hi,

I wrote a script for a button object to export the pivot table to XL. This works good in developer client, but there seems to no action while trying in server through Access point. Could anyone let me know the reason? Appreciate your help. Thanks

Regards,

Sasi.

[pover]

When you are exporting from the server, make sure to use the serverSideExport() or serverSideExportEx() functions in your macro.

Karl

[ksasidhars]

Karl, Thanks much for your responce. I'm a novice in qlikview. Could you please modify my below script to make this work at the server side. Thanks much in advance.

SUB SendToExcel

SET chart = ActiveDocument.GetSheetObject("CH93")

SET p = chart.GetProperties

chart.SendToExcel

END SUB

[pover]

Sasi,

Look for an application called APIGuide.qvw that can help you with your macros.  Here's an example from that guide:

set tb = ActiveDocument.GetSheetObject("CH01")

tb.ServerSideExportEx "C:\test.xml" , ";" , 3 '0=HTML, 1=Text, 2=Bitmap, 3=XML, 4=QVD, 5=BIFF

BIFF would be exporting to Excel.

Karl

[ksasidhars]

Thanks Karl. Really appreciate your help. Also, I'll surely follow your suggestion as well. Thanks

[ksasidhars]

Hi Karl,

I tried this option as well but no luck.

Actually I can export it by using the Send to XL option on chart, but the macro for the button is not working. I've checked all settings for Pop ups/Trusted Sites/File Downloads etc.,

Any help in this is really appreciated. Thank you

[pover]

Sasi,

Do you get the same result if you try to run the macro with the AJAX client, the IE Plugin?  What version of QV are you using?  Macros don't run in the AJAX client in version 11.

Karl

[ksasidhars]

Hi Karl,

I've been checking on QV 11 and 10 SR3 with IE plugin. Both places it is failing when I use this script. But it works when I use the button availabale on the top Right of the chart or right click on chart.

Thanks - Sasi

[adhudson]

Hi,

     This has been reported as a bug to QT and got corrected in Qv 11 SR1 updated version.

     I have attached Qv11 SR1 updated release notes for your reference.

     It was mentioned as bug no: 45461 page no: 10

Regards

Andrew Hudson