topic Fit Zoom to window Macro in QlikView

Fit Zoom to window Macro

ivandrago — Fri, 04 Apr 2014 14:43:24 GMT

Hi,

I have version 11 sr2 installed on the server, I have currently got the
following macro as a OnActivate Sheet Trigger

Sub Zoom
ActiveDocument.GetApplication.WaitForIdle
ActiveDocument.ActiveSheet.FitZoomToWindow
End Sub

It seem to work fine when a user has a 17 inch screen but anything smaller i.e 15 inch screen,
it autosize the sheet to the point it is too small for the user to see the charts etc.. is there an alternative macro that will align all
sheets on the document it activates to its best visualisation?

Thanks

Re: Fit Zoom to window Macro

ivandrago — Mon, 07 Apr 2014 12:48:15 GMT

Anyone?

Re: Fit Zoom to window Macro

fkeuroglian — Mon, 07 Apr 2014 14:34:03 GMT

Hi, you could do something like that

sub mas_zoom

set mysheet=ActiveDocument.ActiveSheet

set sp=mysheet.GetProperties

sp.ZoomFactor = sp.ZoomFactor + 0.1

mysheet.SetProperties sp

end sub

sub menos_zoom

set mysheet=ActiveDocument.ActiveSheet

set sp=mysheet.GetProperties

sp.ZoomFactor = sp.ZoomFactor - 0.1

mysheet.SetProperties sp

end sub

not adjust the screen but allow you to get more or less zoom

---------------------------------------------------------------------------------------------------------------------------------------------

are you using IEPlugin or Full Browser to use FitZoomToWindow?

Good luck

Fernando

Re: Fit Zoom to window Macro

ivandrago — Tue, 08 Apr 2014 00:00:38 GMT

Yes I am using IE plugin, so do I use both the macros you have provided?

Re: Fit Zoom to window Macro

Bill_Britt — Tue, 08 Apr 2014 01:30:22 GMT

Hi Ivan,

There is a document extension that will work for AJAX and you can find it here.

Bill

Re: Fit Zoom to window Macro

fkeuroglian — Tue, 08 Apr 2014 02:52:55 GMT

Hi, try to add the two sub that i gave to you, to have the posibility yo do +zoom and - zoom

good luck

please tell how you do it and if it is work

Fernando

Re: Fit Zoom to window Macro

ivandrago — Tue, 08 Apr 2014 14:55:16 GMT

Thanks Fernando, it looks ok what you have done. Based on the macros you have provided instead of having a macro button for each Zoon In/Zoom Out is it possible to have a slider so when the user moves the slider the screen goes bigger and the decreases when move the slider the other way?

Re: Fit Zoom to window Macro

ivandrago — Thu, 10 Apr 2014 12:59:09 GMT

So is it possible to create a slider that would would increase the screen size?