topic Re: Zooming in QlikView

Zooming

Wed, 15 Feb 2012 17:57:09 GMT

How can we zoom all the sheet objects together in a qlikview dashboard ??

Zooming

pover — Wed, 15 Feb 2012 18:24:21 GMT

I'm not sure I understand what you are looking for, but you can make sheet objects larger if you go to View->Zoom->x%. Then you can select the option to "Apply the Zoom to All Sheets"

Please tell us if you were looking for another answer.

Karl

Zooming

Wed, 15 Feb 2012 18:42:42 GMT

i want to add a button on the sheet so that if i click on that button all the sheet objects get Zoomed

Re: Zooming

pover — Wed, 15 Feb 2012 18:46:49 GMT

In the QV API guide there is a function you can use that will zoom a sheet. The example listed is the following:

set mysheet=ActiveDocument.ActiveSheet
set sp=mysheet.GetProperties
sp.ZoomFactor = 0.9
mysheet.SetProperties sp

So, with this code you could create a macro that gets triggered by the button.

Karl

Zooming

Thu, 16 Feb 2012 06:02:46 GMT

Thanks Karl Pover

Zooming

Thu, 16 Feb 2012 09:09:29 GMT

Thanks. This Macro works but what can be done for fitting the zoom to window ??

Re: Zooming

pover — Thu, 16 Feb 2012 16:33:06 GMT

Here you go.

rem ** fit active sheet zoom to window **
ActiveDocument.ActiveSheet.FitZoomToWindow

All this can be found in the APIGuide.qvw that is installed in your computer when you include documentation in you QV install.

Karl