marco Always Fully Expanded

[#1]

Hi,

i have Pivot Table (CH02)

how can i with the marco changed the "Always Fully Expanded" and not "Fully Expanded"

set chart = ActiveDocument.getSheetObject("CH02")
set chartProperties = chart.GetProperties

Thanks

[#2]

Are you trying to set the Chart property so it is always fully expanded?

If so, use this after what you have (according to the API Guide):

chartProperties.TableProperties.PivotAlwaysFullyExpanded = true
chart.SetProperties chartProperties

[#3]

Hi,

Thanks

what is according to the API Guide (how can i find it ?)

[#4]

Hi,

it works. Thank you very much!

[#5 · Accepted solution]

The API Guide is a QVW containing pretty much everything you need to know about building macros. I believe it should be installed in your Documentation folder. You can also download it from the QlikView site. I use it so much, I seem to have copies of it saved everywhere.

I like to use the Automation Examples tab. If you search in the Methods box for what you're trying to do, you can usually find a good example to at least get you started.