topic Re: Macro not running in access point in QlikView

Macro not running in access point

kkkumar82 — Thu, 24 Dec 2015 05:40:59 GMT

Hi all,

From the community I recently took a macro which exports graphs as image and tables as excel data in to Excel sheets. I am calling that macro on a button click. The macro is running in the local machine but from access point it is not working.

options I used:

From Desktop:

I enabled allow system access mode in tools -> edit module

and in server -> System->Security

Is there anything I am missing. Also the server doesn't contain Msoffice.

Thanks

Kiran Kumar

Re: Macro not running in access point

Anonymous — Thu, 24 Dec 2015 05:47:48 GMT

check this, might be helpful for you:

macros not working on server

Macro not working on server after upgrading to 11.2 SR9

Is possible make macros that run server-side? | QlikView Help, Tips & Hints

Re: Macro not running in access point

kkkumar82 — Thu, 24 Dec 2015 06:24:08 GMT

All,

Does macros execute only using IE plugin, thats what I understood, if so how to change from Ajax plugin to IE plugin,

where we need to change.

Any help ??

Thanks

Kiran Kumar

Re: Macro not running in access point

Anonymous — Thu, 24 Dec 2015 06:28:11 GMT

check this:

How to change Ajax to IE Plug-in

Re: Macro not running in access point

tresB — Thu, 24 Dec 2015 06:31:05 GMT

No, there are macros that run in ajax as well. But yes, some of them do not. Plug in has to be installed in the client system. Plugin exe can be found in the server and you should see a doownload link in the accesspoint. If you don't see, ask your qv admin to enable the download link (setup in qmc).

Re: Macro not running in access point

kkkumar82 — Thu, 24 Dec 2015 06:51:52 GMT

Hi Tresco,

Can we run a macro which creates a excel file as a result, in both the plugin i.e. Ajax and as well as IE plugin.

Thanks

Kiran Kumar

Re: Macro not running in access point

Thu, 24 Dec 2015 06:56:41 GMT

Hi do not think that is possible.

I have used this functionality and it works only in IE plugin.

Re: Macro not running in access point

kkkumar82 — Thu, 24 Dec 2015 07:05:52 GMT

All,

I downloaded the IE plugin in my system and installed it, and try to open the qvw file from access point using Internet Explorer Plugin which is displayed in the expand view in list view in access point but I am getting an error.

I changed the plugin to IE Plugin in QMC also.

Thanks

Kiran Kumar

Re: Macro not running in access point

Thu, 24 Dec 2015 07:08:47 GMT

what error you are getting?

screenshot ?

Re: Macro not running in access point

tresB — Thu, 24 Dec 2015 07:12:01 GMT

Ajax supports few basic ; server-side macros. And seems, the one you need unfortunately won't work.

Re: Macro not running in access point

kkkumar82 — Thu, 24 Dec 2015 07:16:12 GMT

Please find the below attached pic. this is the error Iam getting.

Re: Macro not running in access point

tresB — Thu, 24 Dec 2015 07:22:59 GMT

Perhaps, you have to open 4747 port from your client to server.