topic Re: Arrange columns Pivot Table in QlikView

Arrange columns Pivot Table

Anonymous — Tue, 22 Mar 2016 15:28:16 GMT

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.

Re: Arrange columns Pivot Table

oknotsen — Tue, 22 Mar 2016 20:23:11 GMT

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.

Re: Arrange columns Pivot Table

settu_periasamy — Wed, 23 Mar 2016 03:21:36 GMT

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 )

Re: Arrange columns Pivot Table

Anonymous — Wed, 23 Mar 2016 08:27:24 GMT

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.

Re: Arrange columns Pivot Table

settu_periasamy — Wed, 23 Mar 2016 09:46:14 GMT

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

Re: Arrange columns Pivot Table

Anonymous — Wed, 23 Mar 2016 09:51:48 GMT

by using the promote button to change