topic Re: Changing order Column Table in QlikView

Changing order Column Table

emteam162 — Tue, 26 Feb 2013 12:34:23 GMT

Hi All,

Existe any way to change order column Straight table dynamic by macro ....

i have build my table dynamic and i want to show column straight table by order what i want.

Many thanks for your help.

Best Regards,

Emteam

Gysbert_Wassenaar — Tue, 26 Feb 2013 12:43:45 GMT

Use the MoveExpression and MoveDimension members of the StraightTableBox object.

Example from the apiguide qvw:

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

emteam162 — Tue, 26 Feb 2013 12:54:18 GMT

Hi,

Thanks for your answer.

I'll try your solution .

Best Regards,

Emteam

emteam162 — Tue, 26 Feb 2013 13:32:04 GMT

Could you please help me to do loop

I have ListBox (Name of my All Expression) my idea is when a select value from this listbox i bluid straigth table

ListBox Name of expression

When i select by order in my listBox D,G,M i will have this table

Many thanks for your help

Emteam