Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
irfanmd2010
Contributor
Contributor

Sort by expression

I have 4 column in pivot table as below

OPRevenue   OPPH   Total OP

11                    22                 34

22                   33                 55

I want the order of column changes to

OPPH   OPRevenue   TotalOP

22             11                   34

33              22                  55

How

Is it possible to do using      sort by expression and how .

Please help.

1 Reply
balabhaskarqlik

In Pivot table edit mode,

Under Data area: at Rows, Columns, Measures. Place cursor on one of the area, it'll highlight an action, i.e MOVE. Move field positions, Like we've Promote and demote options in qlikview.

By Move option you can move dimension positions. Not required of sort by expression.