Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
achates2008
Contributor III
Contributor III

Why SetPixWidth doesn't work in accesspoint?

I am using macro to adding dimensions to pivot table dynamically, then use SetPixWidth method to set column width of pivot table, and it is working correctly in QV desktop. However, it doesn't work in access point. See below (SBSMID is not added by macro), all columns are narrowed down. Anyone knows how to solve the problem?

set chart = ActiveDocument.GetSheetObject("CH02")

for i=0 to ubound(boxvalues)

     chart.SetPixWidth i,60

next

1 Reply
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Not all macros are supported in AJAX view. Try the IE plugin and check.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!