Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
Showing results for 
Search instead for 
Did you mean: 

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


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

Please help.

1 Reply

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.