4 Replies Latest reply: Feb 26, 2014 9:34 AM by Nate Hallquist RSS

    Dinamic Resolution

    Andrea Masciulli

      Hello everyone,

      I made a dash QlickView that I see in my PC correctly (via client and web with firefox)

      if I see the same dashboard via IE or on another PC with a different resolution, the instrument panel is not displayed in full-screen and are forced to navigate through the scroll bars.

      There is a system to automatically size the panel according to the resolution of the PC in order to try and fit the objects on a single page?



        • Re: Dinamic Resolution
          Friedrich Hofmann

          Hi Andrea,


          if all the PCs where the app is viewed have QlikView installed, you can always use

          - main menu "View"

          => adapt to screen.


          If some users view the app in IE, the resolution is always slightly divergent - that can't be helped. I am building QlikView_apps here for view on IE (team monitors) and in some of them, the objects seem to be way above the lower edge of the screen...



          Best regards,



            • Re: Dinamic Resolution
              Nate Hallquist

              There is a Macro that you can use, I call it Zoom.  You can add it at the sheet level and it will automatically Fit-to-window your dashboard.  I'll warn you that it isn't perfect, but it works pretty well.



              Sub Zoom

                Set s = ActiveDocument.ActiveSheet


                ActiveDocument.GetApplication.WaitForIdle 300


                'Apply zoom to fit window for current sheet

                ActiveDocument.GetApplication.WaitForIdle 300



                'apply zoom to all other sheets


                ActiveDocument.GetApplication.WaitForIdle 300




              End Sub



              I deploy this as a Sheet Trigger, on Activate sheet.  Simply go to the sheet properties, add an External action, Run Macro, then paste the above script int he Edit Module window.  Do this for each sheet.  Then, as you change sheets, your Dashboard will resize to fit the objects.  Again, this isn't perfect, so be sure to test this out and play with it before you put it in a dashboard.


              This comes with no Garauntees, no warranties.  As far as i know, it works in all versions on QV.


              Good luck.