Dynamic screen resolution

[harleen_singh]

How to make qlikview screen resolution dynamic??

Charts and sheets should be automaticall fit to user screen regardless of developers screen

Any ideas?

thanks

Lavi

[harleen_singh]

Any response on this or it is not possible?

[peschu123]

Hi,

there is a little fix/workaround using a macro to apply "fit zoom to window".

http://blog.qvapps.com/2010/03/10/qlikview-autozoom-macro/

//***Code***

Sub Autozoom

ActiveDocument.GetApplication.WaitForIdle
ActiveDocument.ActiveSheet.FitZoomToWindow

End Sub

//********

But I ran into some problems when zoom is not at 100%...some charts are not drawn correctly(borders etc.).IMHO the best way is, to define a standard resolution which has to be used...

[harleen_singh]

Hii Peschu,

                     where would u suggest me to write this code?

On Sheet active?

thanks

Lavi

[antose]

Hi!

You can add a trigger on the Sheet (OnActivateSheet). Then add “Run Macro” on the Actions

[peschu123]

Hi again and sorry for the late reply,

Antose is right.

I used it via "Settings" --> "Document Properties" --> "Triggers" --> "OnOpen" --> "RunMacro" --> Autozoom (macroname).

But I highly recommend you to use it just as a workaround for "special" situations. In general you should define a standard resolution for your apps.

Or use the smallest available(/needed) resolution for development.

Look at my attached pictures why I say that. This happens when I use zoom. (some charts are not drawn correctly).

I hope this was helpful!

- PS -

[harleen_singh]

Hii Peschu,

         I used following code as you said on at OnOpen event

Sub Autozoom

ActiveDocument.GetApplication.WaitForIdle
ActiveDocument.ActiveSheet.FitZoomToWindow

End Sub

But i think it is doing zooming out the Charts/Objects. Now my chart looks very small now.

my Requirement is not to zoom out charts inside qlikview.

I want Qlikview to change the Sheet resolution when qlikview opens in different Screens.

Thanks

Lavi

[peschu123]

I think this happens when QlikView (main window) is not maximized. The main window has to be maximized that the "Fit zoom to window" function works as expected.

[harleen_singh]

Peschu,

              what do you mean by

"QlikView (main window) is not maximized"??

[peschu123]

The "Windows Buttons" for minimize and maximize...

If Qlikview doesn't start up maximized and you set trigger on load, it will fit the zoom to the "minimized" window and you end up with smaller charts etc....