topic Re: Run Macro Script? in QlikView

Run Macro Script?

Tue, 19 Aug 2014 08:00:29 GMT

Hi,

Can I know why some or most of the "Macro" scripts are not working on web interface?

is there any way to make it work?

eg;

macro such as;

* RELOAD

* FitToScreen

sub max_zoom

set mysheet=ActiveDocument.ActiveSheet

set sp=mysheet.GetProperties

sp.ZoomFactor = sp.ZoomFactor + 0.1

mysheet.SetProperties sp

end sub

sub mini_zoom

set mysheet=ActiveDocument.ActiveSheet

set sp=mysheet.GetProperties

sp.ZoomFactor = sp.ZoomFactor - 0.1

mysheet.SetProperties sp

end sub

Re: Run Macro Script?

tresB — Tue, 19 Aug 2014 08:03:59 GMT

In Ajax? The limitation is known. Read this: macros-are-bad

Re: Run Macro Script?

ashfaq_haseeb — Tue, 19 Aug 2014 08:18:18 GMT

Hi,

You need to know how macros run and where.

The Internet Explorer PlugIn (OCX) or Ajax (JS).

The Plugin runs client side and is quite capable,

whereas the Ajax client is a thin client that cannot run client side macros,

so it is very limited when it comes to the macro functionality.

That's the reason not all macros work in ajax.

Regards

ASHFAQ

Re: Run Macro Script?

Tue, 19 Aug 2014 08:43:31 GMT

Hi,

Thanks every one!

well instead of macros functions is there any other functions I can use, which is work on all the platforms?

Re: Re: Run Macro Script?

ashfaq_haseeb — Tue, 19 Aug 2014 08:47:54 GMT

Yes.

You want to fit zoom to window Right?

Then use this extension.

Regards

ASHFAQ

Re: Run Macro Script?

Tue, 19 Aug 2014 08:56:45 GMT

Hi,

you want me to ass the .qar file on server?

well, am not only talking about fit screen. I want to is there any other function than macro which will work on other platforms so that I can use it...

Re: Run Macro Script?

ashfaq_haseeb — Tue, 19 Aug 2014 09:01:11 GMT

Yes you need to deploy the same on server.

Mafaz Jaufer wrote:

well, am not only talking about fit screen. I want to is there any other function than macro which will work on other platforms so that I can use it...

It depends on what are you trying to do or implement.

May be there is some other or easier way you can achieve that.

It really depends on what are you trying to achieve.

Regards

ASHFAQ

Re: Run Macro Script?

Tue, 19 Aug 2014 09:56:36 GMT

@ Ashfaq: can I create a TOGGLE MENU in QlikView?

Re: Run Macro Script?

ashfaq_haseeb — Tue, 19 Aug 2014 10:03:55 GMT

Hi,

What exactly you are trying to achieve.

Toggle between chart type is native function of Qlik.

Regards

ASHFAQ