Discussion board where members can get started with QlikView.
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....
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...
Go to Solution.
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.
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.
It's not working
Dear John, It's now working... Thanks for your help...