topic Auto Adjust Screen in QlikView

Auto Adjust Screen

Wed, 29 Dec 2010 05:22:59 GMT

Hi All,

There is an option in QlikView to autoadjust to screen size.

Thanks in Advance.

Regards,

Srividhya. S

Auto Adjust Screen

Wed, 29 Dec 2010 05:24:55 GMT

Hi,

There is an option in QlikView to autoadjust to screen size.

Thanks in Advance.

Regards,

Srividhya. S

Auto Adjust Screen

Wed, 29 Dec 2010 05:26:21 GMT

Sorry by mistake clicked verified

Auto Adjust Screen

orital81 — Tue, 29 Nov 2011 08:19:08 GMT

Use this Macro and apply it as a trigger to each Sheet (The Apply to all sheets doesn't seem to work for me)

Sub Zoom

ActiveDocument.GetApplication.WaitForIdle

ActiveDocument.ActiveSheet.FitZoomToWindow

'ActiveDocument.ActiveSheet.ApplyZoomToAllSheets

End Sub

Auto Adjust Screen

christophebrault — Tue, 29 Nov 2011 08:21:50 GMT

Is this macro working on server and ajax view ?

Auto Adjust Screen

orital81 — Tue, 29 Nov 2011 11:35:43 GMT

Works on server, Didn't try with Ajax View.

Auto Adjust Screen

Miguel_Angel_Baeyens — Tue, 29 Nov 2011 11:52:54 GMT

Hi,

That macro code will (FitZoomToWindow) not work with Ajax, since Ajax doesn't have the capability of auto adjust to the screen size. It will work in the Plugin since uses OCX and ActiveX functions that do provide that capability. There is no way to get any similar function with the Ajax client at least for the time being.

Regards.

Miguel

Auto Adjust Screen

Mon, 23 Jan 2012 12:48:01 GMT

If you modify the macro a bit, so that it looks like this:

Sub Zoom

ActiveDocument.GetApplication.WaitForIdle

ActiveDocument.ActiveSheet.FitZoomToWindow

ActiveDocument.GetApplication.WaitForIdle

ActiveDocument.ActiveSheet.ApplyZoomToAllSheets

End Sub

then the ApplyZoomToAllSheets works, too.

Regards,

Marijan