topic Script execution not working in Access point in QlikView

Script execution not working in Access point

ksasidhars — Tue, 10 Jan 2012 00:20:34 GMT

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.

Script execution not working in Access point

pover — Tue, 10 Jan 2012 00:33:40 GMT

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

Karl

Script execution not working in Access point

ksasidhars — Tue, 10 Jan 2012 01:03:04 GMT

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

Script execution not working in Access point

pover — Tue, 10 Jan 2012 01:14:30 GMT

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

Script execution not working in Access point

ksasidhars — Tue, 10 Jan 2012 02:16:47 GMT

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

Script execution not working in Access point

ksasidhars — Wed, 11 Jan 2012 03:19:53 GMT

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

Script execution not working in Access point

pover — Tue, 17 Jan 2012 18:40:17 GMT

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

Script execution not working in Access point

ksasidhars — Tue, 17 Jan 2012 20:50:00 GMT

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

Re: Script execution not working in Access point

adhudson — Mon, 16 Apr 2012 07:01:21 GMT

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