Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Sort in a Pivot Table (Cross Tab)


I have a cross table with customers as rows and year as column across the top. Like below

Customer2012 Revenue2013 Revenue2014 Revenue
Customer 1500450600
Customer 2700490585
Customer 39001150790

How can I sort by 2014 Revenue in descending order?

3 Replies
Highlighted
Champion III
Champion III

Pivot table is always sorted by dimensions, and the first dimension is Customer.  To solve your problem, you can sort Customer by expression, descending, and expression could be like this:

sum({<Year={'2014 Revenue'}>} Revenue)

Highlighted
Specialist II
Specialist II

Hi,

Goto Sort Tab-> Select Numeric  and Expression value as Descending.

Regards

Krishna

Highlighted
Specialist
Specialist

Hi,

Double click on the 2014 year then u can see the sorting type