topic Auto adjust in QV Application in QlikView

Auto adjust in QV Application

Wed, 29 Dec 2010 11:58:24 GMT

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

Auto adjust in QV Application

deepakk — Wed, 29 Dec 2010 12:46:31 GMT

hi srividhya,

You can call the below code on sheet activate

ActiveDocument.ActiveSheet.FitZoomToWindow

Auto adjust in QV Application

Wed, 29 Dec 2010 13:03:59 GMT

Hi deepak,

Thanks for ur reply.

Kindly provide step by step bcoz am new to QV.

Thanks again.

Regards,

Sri

Auto adjust in QV Application

deepakk — Thu, 30 Dec 2010 04:58:17 GMT

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.

Auto adjust in QV Application

Thu, 30 Dec 2010 05:23:20 GMT

Hi Deepak,

Thanks Alot Yar 🙂

Its working fine...

Thanks & Regards,

Srividhya

Auto adjust in QV Application

guytzumer — Thu, 30 Dec 2010 08:12:22 GMT

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

Auto adjust in QV Application

Thu, 30 Dec 2010 08:52:06 GMT

Hi Guy tzumer

Kindly thnx for ur reply.

Regards,

sri

Auto adjust in QV Application

Mon, 03 Jan 2011 07:45:29 GMT

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

Auto adjust in QV Application

Mon, 03 Jan 2011 07:49:30 GMT

Or any other way for the same action

Auto adjust in QV Application

deepakk — Mon, 03 Jan 2011 08:04:07 GMT

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.

Auto adjust in QV Application

Mon, 03 Jan 2011 10:10:29 GMT

thnx yar tht thing s wrking fine

Regards,

Sri