topic Re: Export to excel not working at access point level in QlikView

Export to excel not working at access point level

rsdhavle — Tue, 07 Jan 2014 09:42:09 GMT

HI,

I have written Vb script for getting output into excel but when i deploy that file through publisher and try to get output in excel through access point i am not able to get output into excel. It does not work. Why is that happening?

Re: Export to excel not working at access point level

Siva_Sankar — Tue, 07 Jan 2014 09:48:35 GMT

If you're using Ajax to view the Qlikview report, macro will not work. You can use the default excel to export function available in the qlikview objects like charts.

Regards.

Siva

Re: Export to excel not working at access point level

Anonymous — Tue, 07 Jan 2014 09:49:12 GMT

Try with External Task in Publisher,

Regards

Davide

Re: Export to excel not working at access point level

sanketkhunte — Tue, 07 Jan 2014 09:49:51 GMT

Hello Rohan,

Don't use micro because they are not working on access ponit. Use inbuild property of objects "Export to Excel"

If you don't have any option without macro -: check "SYSTEM ACCESS" check box checked.

Thank you.

Sanket

Re: Export to excel not working at access point level

Tue, 07 Jan 2014 09:52:24 GMT

Hi Rohan,

In Ajax it will not support the external macros to export. qlikview default export you can use.

Re: Export to excel not working at access point level

brijesh1991 — Tue, 07 Jan 2014 09:52:36 GMT

Press Shift+Ctrl+M

And check "Give System Access to Module Script"

Re: Export to excel not working at access point level

Tue, 07 Jan 2014 09:56:18 GMT

Hi Rohan,

Which mode are you using to view your qlikview file?

Reason being, there are few actions/triggers/macros which won't work in AJAX mode.

If you are using AJAX then you can refer to below url for further info on which Action/Trigger is supported in which mode

Re: AJAX with OnOpen macro

EDIT : Also you can try checking the below:

in macro editor page.

Hope this helps!

Re: Export to excel not working at access point level

jafari_ervin — Tue, 19 Aug 2014 07:48:01 GMT

Default export action not work in ajax mode