Arrange columns Pivot Table

[Anonymous]

Hello,

I'm new to QlikView, and I do not see how I can arrange the columns of my table Pivot easily.

Do you have a solution ?

Thank you in advance for your help,

Cocalero.

[oknotsen]

Click on the column name. Keep your mouse button pressed. Move your mouse around till the arrow shows up in the location and direction you want to have your column in.

[settu_periasamy]

Another way, There is option 'Promote' and 'Demote' in the Dimensions Tab of Properties Window..

And, if you want to Move your Month Field on top (row wise), Click the Month Field (Hold it , Blue vertical line appear) drag and drop to top (you can see the horizontal blue line )

[Anonymous]

Thanks for your response, but it doesn't work :/.
Because i don't want to re-arrange a dimension but the order of values into a dimension, like that:

Put the line "Sales/Struct" after "Trader/ID" for example.

Thank you in advance for your help,

Cocalero.

[settu_periasamy]

I think you are talking about the 'Sort' Option. If so, you can like

Chart Properties -> Sort Tab -> Expression option

Match([Job Title],'Trader/ID','Sales/Struct','EXECBROKER','Mgt','CSNE, Trainee')

Note:

Red color value should exactly match your Job Title value

[Anonymous]

by using the promote button to change