topic Export macro does not work on AccessPoint? in QlikView

Export macro does not work on AccessPoint?

Wed, 12 Nov 2014 02:48:09 GMT

Hi All,

we have a small application in which we created a button and applied macro to export the straight table data to an excel sheet. it all fine on desktop.

when i open the same document on access point, Export button does not work.

the path for the Excel destination after export is C:\Temp\test.xlsx. we are Using Qlikview 11.20 (IE plugin is installed by default???).

i have read lot of posts in the community and tried few things like provided system access to Macro, IE settings etc..

but nothing worked for me. our application link looks something like below:

http://<ServerName>/QvAJAXZfc/opendoc.htm?document=AP/<DocName>.qvw&host=QVS@<ServerName>.

Can someone please suggest what should be done to achieve this task?

and also, when i give the path as C:\Temp\test.xlsx, does it get stored on server folder or local desktop folder?

I am new to qlikview.. so please help..

Thanks

Jyothi

Re: Export macro does not work on AccessPoint?

Anonymous — Thu, 13 Nov 2014 03:27:56 GMT

Hey.

try to give the generic path using variable or direct.

ex: ..\test\template.xlsx

Re: Export macro does not work on AccessPoint?

jagan — Thu, 13 Nov 2014 03:47:30 GMT

Hi,

C:\Temp\test.xlsx, get stored local desktop folder you are accessing the Dashboard.

If you want to save this in server try like this

Share this drive C:\Temp, and now give the shared drive path in the macro

\\SomeIp\SharedDriveName\test.xlsx

Hope this helps you.

Regards,

Jagan.

Re: Export macro does not work on AccessPoint?

mjm — Thu, 13 Nov 2014 11:30:55 GMT

Hello Jyothi,

I seem to remember hearing of issues not working in general in either the Ajax client or the IE plugin. I would suggest trying the other client type to what you are trying.

In any case, the export may fail as you are trying to export to a file location which is unlikely to exist on the devices of all accessed clients, especially if this client is accessing via a mobile device.