Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Auto adjust in QV Application

Hi All,

Need to adjust QV application automaticaly thts it must be fit to screen if we change it diff system. There is an option in QlikView to autoadjust to screen size.

Thanks in Advance.

Regards,

Srividhya. S

1 Solution

Accepted Solutions
Highlighted
guytzumer
New Contributor III

Auto adjust in QV Application

in addition you can add ... the below

Sub Zoom

rem ** fit active sheet to window and apply same zoom to all sheets **

ActiveDocument.ActiveSheet.FitZoomToWindow

ActiveDocument.GetApplication.WaitforIdle

ActiveDocument.ActiveSheet.ApplyZoomToAllSheets

End Sub



and do macro OnOpen and it should go for all Sheets ..

if you facing a prablom jest make a botton on the first sheet thet make this macro

10 Replies
deepakk
Valued Contributor III

Auto adjust in QV Application

hi srividhya,

You can call the below code on sheet activate

ActiveDocument.ActiveSheet.FitZoomToWindow



Not applicable

Auto adjust in QV Application

Hi deepak,

Thanks for ur reply.

Kindly provide step by step bcoz am new to QV.

Thanks again.

Regards,

Sri

deepakk
Valued Contributor III

Auto adjust in QV Application

Hi Srividhya,

Ctr+ M for Module editor.

Sub Test

ActiveDocument.ActiveSheet.FitZoomToWindow

end Sub

(Do the below step for 2-3 sheets and check if it helps you out.)

Now go to Sheet properties -> Trigger tab.

Add Action to OnActivateSheet. In Action Type select External --> Run Macro and In Macro Name give Test.

Not applicable

Auto adjust in QV Application

Hi Deepak,

Thanks Alot Yar Smiley Happy

Its working fine...

Thanks & Regards,

Srividhya

Highlighted
guytzumer
New Contributor III

Auto adjust in QV Application

in addition you can add ... the below

Sub Zoom

rem ** fit active sheet to window and apply same zoom to all sheets **

ActiveDocument.ActiveSheet.FitZoomToWindow

ActiveDocument.GetApplication.WaitforIdle

ActiveDocument.ActiveSheet.ApplyZoomToAllSheets

End Sub



and do macro OnOpen and it should go for all Sheets ..

if you facing a prablom jest make a botton on the first sheet thet make this macro

Not applicable

Auto adjust in QV Application

Hi Guy tzumer

Kindly thnx for ur reply.

Regards,

sri

Not applicable

Auto adjust in QV Application

Hi Kurup,

Please find the attachment its cums every time while am opening the application 1st time in every tab.

let me knw the solution.

Thanks in advance

Regards.

Sri

Not applicable

Auto adjust in QV Application

Or any other way for the same action

deepakk
Valued Contributor III

Auto adjust in QV Application

Hi Srividya,

try out wat Guy has suggested and trigger it in the open event of the application and check if you are facing the issue.

Community Browser