Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can we zoom all the sheet objects together in a qlikview dashboard ??
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
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
i want to add a button on the sheet so that if i click on that button all the sheet objects get Zoomed
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
Thanks Karl Pover
Thanks. This Macro works but what can be done for fitting the zoom to window ??
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