topic Sort in a Pivot Table (Cross Tab) in QlikView

Sort in a Pivot Table (Cross Tab)

chiranjivdas — Tue, 03 Feb 2015 21:34:57 GMT

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

Customer	2012 Revenue	2013 Revenue	2014 Revenue
Customer 1	500	450	600
Customer 2	700	490	585
Customer 3	900	1150	790

How can I sort by 2014 Revenue in descending order?

Re: Sort in a Pivot Table (Cross Tab)

Anonymous — Tue, 03 Feb 2015 21:45:29 GMT

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)

Re: Sort in a Pivot Table (Cross Tab)

krishna20 — Wed, 04 Feb 2015 08:03:13 GMT

Hi,

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

Regards

Krishna

Re: Sort in a Pivot Table (Cross Tab)

Anonymous — Wed, 04 Feb 2015 08:25:49 GMT

Hi,

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