Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
rsdhavle
Creator II
Creator II

Export to excel not working at access point level

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?

7 Replies
Siva_Sankar
Master II
Master II

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

Anonymous
Not applicable

Try  with External Task in Publisher, Task.png

Regards

Davide

sanketkhunte
Creator II
Creator II

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

Not applicable

Hi Rohan,

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

brijesh1991
Partner - Specialist
Partner - Specialist

Press Shift+Ctrl+M

And check "Give System Access to Module Script"

Not applicable

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:

macro.bmp

in macro editor page.

Hope this helps!

jafari_ervin
Creator III
Creator III

Default export action not work in ajax mode