topic Re: How to auto activate Fit zoom To windows in QlikView

How to auto activate Fit zoom To windows

paulyeo11 — Mon, 01 Jul 2013 13:37:42 GMT

Hi All

i need to automatic turn on Fit zoom to windows when i go to every sheet. can some one tell me how to do it ?

it is possiblw to do it with out macro ?

Paul

Re: How to auto activate Fit zoom To windows

Mon, 01 Jul 2013 16:13:23 GMT

Yes it is possible

Try this macro, and fire it with a trigger on the opening of your sheet

sub fit
ActiveDocument.ActiveSheet.FitZoomToWindow
end sub

Re: How to auto activate Fit zoom To windows

rustyfishbones — Mon, 01 Jul 2013 19:47:47 GMT

Hi,

You can check out this video on Youtube

Qlikview Zoom to Fit Macro by RFB 96

http://youtu.be/BN5prtvCVE0

Re: How to auto activate Fit zoom To windows

paulyeo11 — Tue, 02 Jul 2013 02:32:20 GMT

Hi All

I try button it work fine. But when i try to go to sheet properity to set trigger event when turn on sheet , it does not work. i also read from other post , it also reported it have bug on it , i am using ver 9. hope some one can confirm on this.

Re: How to auto activate Fit zoom To windows

Tue, 02 Jul 2013 08:34:36 GMT

I have a V9 installed on my computer and it works for me.

Please check you QV release : mine is SR7

Re: How to auto activate Fit zoom To windows

paulyeo11 — Tue, 02 Jul 2013 11:37:36 GMT

Hi Sir

Thank you , i know why ne ot working ,as i am not activate sheet using tab , i use button and it does not work.

Paul

Re: How to auto activate Fit zoom To windows

Tue, 02 Jul 2013 11:51:41 GMT

Well it works for me even when I use a button to activate the sheet.

If it dosnt for you, you can fire the macro in the actions of the button !

Re: How to auto activate Fit zoom To windows

paulyeo11 — Tue, 02 Jul 2013 12:01:55 GMT

Hi Sir

I have enclosed my sample doc , which is having problem , when i try to run macro on zoom using button. Hope you can take a look.

Re: How to auto activate Fit zoom To windows

Tue, 02 Jul 2013 13:20:15 GMT

I have difficulities to understand your app

but it seams to work on my qv 9

Re: How to auto activate Fit zoom To windows

paulyeo11 — Tue, 02 Jul 2013 13:26:41 GMT

it is okay , i think i to live with it , may be later i should be able to figure out .

Re: How to auto activate Fit zoom To windows

Wed, 30 Oct 2013 14:37:51 GMT

Hi yadurand,

thanks for the macro, it works great when I'm using it in the client. On the server, however, it doesn't work - even though all macros are allowed in the server settings.

Do you have any idea why that is? Do VB-script-macros work on the server, or does that only work with jscript?

Best regards,

Tim