topic Re: Dynamic screen resolution in QlikView

Dynamic screen resolution

harleen_singh — Thu, 18 Apr 2013 10:00:50 GMT

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

Re: Dynamic screen resolution

harleen_singh — Thu, 25 Apr 2013 09:57:15 GMT

Any response on this or it is not possible?

Re: Dynamic screen resolution

peschu123 — Thu, 25 Apr 2013 10:58:56 GMT

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...

Re: Dynamic screen resolution

harleen_singh — Fri, 17 May 2013 09:11:43 GMT

Hii Peschu,

where would u suggest me to write this code?

On Sheet active?

thanks

Lavi

Re: Dynamic screen resolution

antose — Fri, 17 May 2013 10:00:35 GMT

Hi!

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

Re: Dynamic screen resolution

peschu123 — Fri, 17 May 2013 12:52:03 GMT

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 -

Re: Dynamic screen resolution

harleen_singh — Mon, 20 May 2013 11:09:07 GMT

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

Re: Dynamic screen resolution

peschu123 — Tue, 21 May 2013 07:33:09 GMT

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.

Re: Dynamic screen resolution

harleen_singh — Tue, 21 May 2013 08:57:25 GMT

Peschu,

what do you mean by

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

Re: Dynamic screen resolution

peschu123 — Tue, 21 May 2013 12:19:55 GMT

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....

Re: Dynamic screen resolution

Tue, 02 Jul 2013 18:33:13 GMT

Hello - We have Doc's with multiple tabs and multiple users going through Access Point with possibly just as many different screen resolutions.

Would you suggest to set this trigger up to run on each sheet of a document?

Regards, Däv

Re: Dynamic screen resolution

Wed, 11 Dec 2013 09:58:24 GMT

This macro does not work in Access Point! Right?

Re: Dynamic screen resolution

harleen_singh — Thu, 12 Dec 2013 10:08:44 GMT

Yes it doesn't work...