Qlikview macro to automatically Fit zoom to window

Question

How can i create a macro to automatically Fit zoom to window.

I cant see an options to do this via a trigger.

Preferably i would like this macro to be triggered when the screen resolution changes, if not possible i would like it to be set when you change sheets.

score 1 · Accepted Answer · answered Mar 03 '15 at 14:52

1

Ctrl + m to open the macro editor

Sub FZTW    
    ActiveDocument.ActiveSheet.FitZoomToWindow  
End Sub

Set when sheet activate trigger macro FZTW

answered Mar 03 '15 at 14:52

Matt

14,906
27
99
149

score 1 · Answer 2 · answered Jan 11 '16 at 05:43

for anybody who searched for Fit Zoom to Window and end up here

enable plugin in server and check show download link
client now download the plugin& go to detail and view it with this around 96mb plugin.
inside plugin top toolbar go to Menu->Zoom->Fit Zoom to Window

Qlikview macro to automatically Fit zoom to window

2 Answers2