Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
krishnacbe
Partner
Partner

Scree Resolution Problem

Hi

I have used below steps to Fit the Screen

Go to Tools -> Edit Module

Sub Zoom
ActiveDocument.GetApplication.WaitForIdle
ActiveDocument.ActiveSheet.FitZoomToWindow
End Sub

Click "OK"

Setting -> Sheet Properties

Select the "Triggers" tab

Click the "Add Action(s)..." button under OnActiveSheet

Click Add

Select "External" from the left hand list and "Run Macro" from the right hand list. Click "OK"

Type "Zoom" under Macro Name

Click "OK" until you have exited all the windows.

This works fine in Qlikview Desktop. In IE Plugin some problem occurs, screen is not fit to the window. I am using IE 8 version.

Thanks In advance

1 Reply
fosuzuki
Partner
Partner

Hi,

try this code, I've found on the community some time ago...:

sub ZoomWithErrorCheck

          set doc = ActiveDocument

          set aSheet = doc.ActiveSheet

          aSheet.FitZoomToWindow

          doc.GetApplication.WaitForIdle 300

          aSheet.ApplyZoomToAllSheets     'if you want the same zoom to be applied to the other sheets

end sub

Hope this helps you

Fernando