Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Qlikview Zoom to Fit only width

Hi every one,

here i am facing a problem that when i am using macro for zoom functionality it is adjusting the sheet to my screen in both vertically & horizontally and objects is getting compressed.

Now what i want is when i click on full screen button the objects should only adjust it's width and dimensions should change.While height of the object should be same.

at time of loading, iam able to see the screen with scroll

Qlik zoom 1.jpg

after click on "full screen" button

qlik zoom.jpg

it is adjusting its height also and objects are comprossed.

Please help

thanks in advance

11 Replies
Anil_Babu_Samineni

What was the code you written over there? I mean Macro

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable
Author

Sub Autozoom

ActiveDocument.GetApplication.WaitForIdle

ActiveDocument.ActiveSheet.FitZoomToWindow

End Sub

Anil_Babu_Samineni

I am not facing any issue on server too along with Reload as well. I don't think what you have done over there.

Because, Since 2 Years i am doing same script to do this. Would you able to share sample to look

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable
Author

please go through the attachment .

on opening the document every thing is fine, but on clik on full screen button objects will compress

Anil_Babu_Samineni

Error Facing while opened, Can you reattach for me, Please?

Capture1.PNG

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable
Author

try now

Anil_Babu_Samineni

Trust me. This is working for me

I am using this Version?

Capture.PNG

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anil_Babu_Samineni

One more thing, I want to add one point.

Here, You screen resolution should be 1024x768. So then it would work. And one most point here you need to cover up and resize to Single page without Scroll Downs and Sides. Then only This code works.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable
Author

hi anil,

but i want with Scroll , is there any chance to fix that.

because i want to show all sheets in summary page and details in another page as in table format