Open a dashboard with fit zoom to window

[felipe_oliveira]

Hi masters

Is there a way to open Qlikview and have the "Fit Zoom to Window" automatically applied to all sheets?

I have tried inserting the following on triggers but it did not work

Sub Zoom

ActiveDocument.ActiveSheet.FitZoomToWindow

ActiveDocument.ActiveSheet.ApplyZoomToAllSheets

End Sub

Please advise

Regards

Felipe Oliveira

[MK9885]

Fit Zoom to Window Document Extension

Extension only works in webmode or maybe Access Point.

[Anil_Babu_Samineni · Accepted solution]

May be this? You should call Zoon into OnOpen Trigger

Sub Zoom

ActiveDocument.GetApplication.WaitForIdle

ActiveDocument.ActiveSheet.FItZoomToWindow

End Sub

[ludwikkaminski]

Hi,

It should be done in two diferent macro and then run one by one in two diferent action:

Sub FitZoomToWindow
ActiveDocument.GetApplication.WaitForIdle
ActiveDocument.ActiveSheet.FitZoomToWindow
ScreenUpdating = True
end sub

Sub ZoomToAllSheets
ActiveDocument.GetApplication.WaitForIdle
ActiveDocument.ActiveSheet.ApplyZoomToAllSheets
ScreenUpdating = True
end sub

BR

Ludzik