Promote and Demote

[perumal_41]

Hi Qlikview Experts,

Please guide me expression Promote and Demote  through macro in Object .

Regards

Perumal A

[Gysbert_Wassenaar]

You can use the MoveDimension and MoveExpression members of the chart object.

Examples from the com api:

rem create new straight table and switch places of dimension columns

set chart = ActiveDocument.Sheets("Main").CreateStraightTable

chart.AddDimension "ProductType"

chart.AddDimension "ProductGroup"

chart.AddExpression "sum(Amount)"

chart.MoveDimension 1,0

rem create new straight table and switch places of expression columns

set chart = ActiveDocument.Sheets("Main").CreateStraightTable

chart.AddDimension "ProductType"

chart.AddExpression "sum(Amount)"

chart.AddExpression "count(Product)"

chart.MoveExpression 1,0

[perumal_41]

Hi Gysbert Wassenaar,

Thanks for Valueble  time spend for me.but I Don't want create new object .I have  Already Created Chart,in this chart i want do  Expression promote and demote

Regards

Perumal

[#4]

How many expressions You've got in that chart?

[perumal_41]

Hi,

I have 10 Expression  in Chart based on selection expression want promote or demote .

Regards

Perumal A