topic Re: Fit Zoom to WIndow Button in QlikView

Fit Zoom to WIndow Button

Anonymous — Mon, 10 Feb 2014 14:40:50 GMT

Hello,

I would like to create a Fit Zoom to Window button to help our users adjust their apps to the many different monitor sizes that are used in the company. Any help on this will be greatly appreciated.

Re: Fit Zoom to WIndow Button

jpapador — Mon, 10 Feb 2014 15:06:19 GMT

You can add this code as a macro and it will zoom to window:

Sub Zoom

Set s = ActiveDocument.ActiveSheet

ActiveDocument.GetApplication.WaitForIdle 300

'Apply zoom to fit window for current sheet

ActiveDocument.GetApplication.WaitForIdle 300

s.FitZoomToWindow

'apply zoom to all other sheets

ActiveDocument.GetApplication.WaitForIdle 300

s.ApplyZoomToAllSheets

End Sub

Re: Fit Zoom to WIndow Button

Peter_Cammaert — Mon, 10 Feb 2014 15:09:17 GMT

There is no possibility to zoom in the AccessPoint, so I think you're talking about Desktop or Plugin users.

Write a macro like presented in the first post of this discussion: Fit zoom to window Macro in Access Point

Attach the macro to a button using an action type External->Run Macro

Note that you cannot let a desktop window resize trigger this macro automatically, because QlikView has no events for this.

Best,

Peter

Re: Fit Zoom to WIndow Button

Anonymous — Mon, 10 Feb 2014 16:39:02 GMT

Thanks, new to developing and didn't think about end user's screen not having function. Would probably be confusing for them to have a Zoom button that did not zoom for Access Point users.