topic marco Always Fully Expanded in QlikView

marco Always Fully Expanded

Thu, 05 Nov 2009 20:45:21 GMT

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

marco Always Fully Expanded

Thu, 05 Nov 2009 21:45:38 GMT

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

marco Always Fully Expanded

Thu, 05 Nov 2009 22:02:00 GMT

Hi,

Thanks

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

marco Always Fully Expanded

Thu, 05 Nov 2009 22:24:42 GMT

Hi,

it works. Thank you very much!

marco Always Fully Expanded

Thu, 05 Nov 2009 22:34:59 GMT

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.