Solved: Re: Macro and Hyperlink not working in Ajax - Qlik Community

Report Inappropriate Content · ‎2013-06-26

I have insalled and configured a Qlikview Server 11 SR2 machine with all option enabled for macro execution.

All works well in IE Plugin, but macro for excel export does not work in Ajaxzfc (full browser option).

the macro is:

ActiveDocument.GetSheetObject("CH160").SendToExcel()

Also I have included a world map referencing google's api chart (http://chart.apis.google.com/chart?&cht=t) and this not working properly on Full Browser Version (Ajaxzfc).

Any suggestion?

Thankyou.

gainkarthi · ‎2013-06-26

Adding to the above note please find the difference between IE and Ajax

AJAX	IE Client Plug in
1. No extra download and Installation required. Good for Chrome, firefox and safari	1.IE plug-in is required
2. Direct tunneling, much faster over HTTPs	2. Faster in selections, depend upon the configuration
3. Good for Mobile Device	3. Feature is not available
4. Requires ports 4747 and 477e open in both client and the server both inbound and outbound	4.This is done over HTTPs. So no port issue. 443 is usually open.
5.MS Office Integration is difficult	5.Microsoft Office drag and drop only available in IE plug in
6.Macro and alert is not possible	6.Alerts can only be created and triggered from Windows (IE Plug-in) versions of QlikView
7. The communication between a QlikView Server and a QlikView Windows client is encrypted. If, however, the AJAX client is used, the communication is not encrypted	7. By default Https. man-in-the-middle and eavesdropping attacks is less possible.

View solution in original post

gainkarthi · ‎2013-06-26

Macro wont work in AJAX page and it will work only with IE Plugin.

gainkarthi · ‎2013-06-26

Adding to the above note please find the difference between IE and Ajax

AJAX	IE Client Plug in
1. No extra download and Installation required. Good for Chrome, firefox and safari	1.IE plug-in is required
2. Direct tunneling, much faster over HTTPs	2. Faster in selections, depend upon the configuration
3. Good for Mobile Device	3. Feature is not available
4. Requires ports 4747 and 477e open in both client and the server both inbound and outbound	4.This is done over HTTPs. So no port issue. 443 is usually open.
5.MS Office Integration is difficult	5.Microsoft Office drag and drop only available in IE plug in
6.Macro and alert is not possible	6.Alerts can only be created and triggered from Windows (IE Plug-in) versions of QlikView
7. The communication between a QlikView Server and a QlikView Windows client is encrypted. If, however, the AJAX client is used, the communication is not encrypted	7. By default Https. man-in-the-middle and eavesdropping attacks is less possible.

Report Inappropriate Content · ‎2013-06-26

Thankyou very much Karthikeyan Subramaniam

Now i have to find a method to call export excel in ajax, because I have some minimized object, and macro was created for excel export of these objects.