[ASK] How to make the QlikView's view/Sheet fit to screen resolution

[#1]

hello all,

need help plis..

How to make the QlikView's view/sheet fit to screen resolution?

when i create my Qlikview project on my laptop, i make it fit to my laptop resolution,

but when i use it to presentation to my manager through Projector, the qlikview's view become half ( have scrollbar in right and under the screen).

the resolution of the projector is smaller than my laptop, but the qlikview resolution still same with my laptop size, and it cause the qlikview's view iin half.

so how to make the qlikview resolution fit to another laptop, PC, projector , or etc?

sory my english is poor,

thx for your help

best regards !

[vgutkovsky · Accepted solution]

Try going to View --> Fit Zoom to Window.

Regards,

[#3]

great,

thank you vlad

regards!

[#4]

You can also add a button that will run this macro... that way any user can just click and have it auto-resize.

Sub ZoomToWindow

ActiveDocument.GetApplication.WaitForIdle 300
ActiveDocument.ActiveSheet.FitZoomToWindow

ActiveDocument.GetApplication.WaitForIdle 300
ActiveDocument.ActiveSheet.ApplyZoomToAllSheets

End Sub

[#5]

apology, but where is the view option

[#6]

At the top of window.... next to "File"

[#7]

Hi Riedl,

I'm just writing to say that your solution is the most efficient of all I searched on the site. I did some tests and the big difference from your code is that it repeats the line "WaitForIdle" and enter the value 300 to the end of it.

Congratulations

Stive

[#8]

To zoom to whatever the user wants and for all sheets, create a slider bar that has a variable (vZoom) for the data.

Then have the variable trigger On Change to the following macro.

sub ZoomToFit
for i = 0 to ActiveDocument.NoOfSheets - 1

set ss= ActiveDocument.GetSheet(i)
set sp=ss.GetProperties
set v = ActiveDocument.GetVariable("vZoom")
sp.ZoomFactor = v.GetContent.string/100
ss.SetProperties sp
next
end sub

hth,

Stephen