topic SORTING IN PIVOT TABLE in QlikView

SORTING IN PIVOT TABLE

Tue, 09 Aug 2011 16:40:21 GMT

I have customer wise sales data per month. I have created a pivot table showing Customer Name Vs Monthwise sales.

Also sorted data decreasing manner for total sale per customer.

Data for first few customers shown below....

Customer Name	Month	Total	Jan	Feb	Mar	Apr	May	Dec
Total		7,569,868	866,396	917,070	904,956	660,191	1,284,303	639,091
Customer 1		987,912	117,230	121,298	160,146	89,691	128,454	1,453
Customer 2		743,881	179,022		62,593	56,743	118,122	96,074
Customer 3		524,923	6,537	109,203	89,726
Customer 4		497,782					497,782
Customer 5		395,612	118,459	93,752	133,721	12,445		8,350
Customer 6		341,994	14,474	8,994		81,600	3,786	133,288

My problem is from above table December Month data is for 2010 while January to May months sale is for 2011.

So I need this pivot table should show data as DEC JAN FEB MAR APR MAY...

Please help...

SORTING IN PIVOT TABLE

its_anandrjs — Tue, 09 Aug 2011 16:54:56 GMT

Hi,

You need to sort your Month Colum by Decending order then the pivot chart automatically display Dec,Jan,Feb,mar,Apr,May by Properties->Sort->Expression->Select Month column then select Descending order.

Regards,

Anand

SORTING IN PIVOT TABLE

Tue, 09 Aug 2011 17:37:49 GMT

It's not working

Re: SORTING IN PIVOT TABLE

johnw — Tue, 09 Aug 2011 17:53:11 GMT

Are your months defined like this?

month(Date) as Month

If so, that's why they don't sort with the year taken into account. To include the year, define your months as dates:

date(monthstart(Date),'MMM YYYY') as Month

You don't HAVE to include YYYY there, if you only want to show the month name, but I think it'll be confusing without it.

SORTING IN PIVOT TABLE

Tue, 09 Aug 2011 17:59:24 GMT

Dear John, It's now working... Thanks for your help...