topic Re: Promote and Demote in QlikView

Promote and Demote

perumal_41 — Wed, 06 Mar 2013 06:04:57 GMT

Hi Qlikview Experts,

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

Regards

Perumal A

Re: Promote and Demote

Gysbert_Wassenaar — Wed, 06 Mar 2013 10:35:41 GMT

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

Re: Promote and Demote

perumal_41 — Wed, 06 Mar 2013 10:44:46 GMT

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

Re: Promote and Demote

Wed, 06 Mar 2013 10:56:50 GMT

How many expressions You've got in that chart?

Re: Promote and Demote

perumal_41 — Wed, 06 Mar 2013 11:05:48 GMT

Hi,

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

Regards

Perumal A