Why SetPixWidth doesn't work in accesspoint?

achates2008 — Thu, 19 Jul 2018 05:46:53 GMT

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

Re: Why SetPixWidth doesn't work in accesspoint?

kaushiknsolanki — Thu, 19 Jul 2018 05:54:57 GMT

Hi,

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

Regards,

Kaushik Solanki

topic Why SetPixWidth doesn't work in accesspoint? in QlikView

Why SetPixWidth doesn't work in accesspoint?

Re: Why SetPixWidth doesn't work in accesspoint?