topic Re: Change screen resolution in QlikView

Change screen resolution

johanlind — Tue, 29 Jul 2014 06:33:05 GMT

Is there a way to change the screen resolution with a macro?

Re: Change screen resolution

c_gilbert — Tue, 29 Jul 2014 07:54:41 GMT

I don't think so, but you can allow zooming with macros:

Sub ZoomFitToWindow

ActiveDocument.ActiveSheet.FitZoomToWindow
ActiveDocument.GetApplication.WaitforIdle
ActiveDocument.ActiveSheet.ApplyZoomToAllSheets

End Sub

sub ZoomIn

set mysheet=ActiveDocument.ActiveSheet
set sp=mysheet.GetProperties
sp.ZoomFactor = sp.ZoomFactor * 1.1
mysheet.SetProperties sp
ActiveDocument.GetApplication.WaitforIdle
ActiveDocument.ActiveSheet.ApplyZoomToAllSheets

end sub

sub ZoomOut

set mysheet=ActiveDocument.ActiveSheet
set sp=mysheet.GetProperties
sp.ZoomFactor = sp.ZoomFactor * 0.9
mysheet.SetProperties sp
ActiveDocument.GetApplication.WaitforIdle
ActiveDocument.ActiveSheet.ApplyZoomToAllSheets

end sub

Sub ZoomNormal

set mysheet=ActiveDocument.ActiveSheet
set sp=mysheet.GetProperties
sp.ZoomFactor = 1
mysheet.SetProperties sp
ActiveDocument.GetApplication.WaitforIdle
ActiveDocument.ActiveSheet.ApplyZoomToAllSheets

End Sub

Re: Change screen resolution

johanlind — Tue, 29 Jul 2014 08:57:00 GMT

I know how to change the zoom.

I want to take a screenshot/picture of a sheet with a macro, and the zoom function won't work with my macro for saving a picture.

Here is my macro for export a picture:

public function ExportImage

vFolder = Destination folder

ActiveDocument.GetSheetByID ("SH02").Activate

set obj = ActiveDocument.GetSheetByID("SH02")

ActiveDocument.GetApplication.WaitForIdle

fileName = "SH02" & ".jpg"

ActiveDocument.GetApplication.WaitForIdle

obj.ExportBitmapToFile vFolder & fileName

end function

Any other ideas for doing this?

Re: Change screen resolution

aveeeeeee7en — Tue, 29 Jul 2014 09:05:15 GMT

See this:

Resize screen objects to fit with screen size:

How to know our Qlikview report resolution ?

Re: Change screen resolution

johanlind — Tue, 29 Jul 2014 09:14:43 GMT

When I use the export function all objects will be exported in its original size, but the window(picture) size will change to the resolution I have set the window to.

Re: Change screen resolution

Anonymous — Mon, 09 Feb 2015 10:12:59 GMT

Did you ever find a solution to this?

I am most likely trying to exactly the same and am stuck between resolutions for a logged on computer, the server default resolution etc.

Kind regards

Niklas