Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
guytzumer
Partner - Contributor III
Partner - Contributor III

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

View solution in original post

10 Replies
deepakk
Partner - Specialist III
Partner - Specialist III

hi srividhya,

You can call the below code on sheet activate

ActiveDocument.ActiveSheet.FitZoomToWindow



Not applicable
Author

Hi deepak,

Thanks for ur reply.

Kindly provide step by step bcoz am new to QV.

Thanks again.

Regards,

Sri

deepakk
Partner - Specialist III
Partner - Specialist III

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
Author

Hi Deepak,

Thanks Alot Yar 🙂

Its working fine...

Thanks & Regards,

Srividhya

guytzumer
Partner - Contributor III
Partner - Contributor III

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
Author

Hi Guy tzumer

Kindly thnx for ur reply.

Regards,

sri

Not applicable
Author

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
Author

Or any other way for the same action

deepakk
Partner - Specialist III
Partner - Specialist III

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.