Month Order

upaliwije — Sun, 13 Apr 2014 01:56:07 GMT

Hi Friends

I have attached a QVW file and the supporting work sheet. I want your help to do the following

1.Create master Calender with Year_Month as field

2. When I select an Year_Month that particular month should be the 1st Column of the Pivot table other months after that

Eg : If I select 2013_05 as Year_Month my pivot table should look like as follows

YEAR	MONTH	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC	JAN	FEB	MAR	APR
2013	1	5,332,799	4,778,475	5,820,451	4,327,208	4,492,297	5,708,382	5,472,065	5,573,470	4,122,270	5,139,520	6,129,330	4,060,620
2013	2	5,332,799	4,778,475	5,820,451	4,327,208	4,492,297	5,708,382	5,472,065	5,573,470	4,122,270	5,225,041	6,129,330	4,060,620
2013	3	5,332,799	4,778,475	5,820,451	4,327,208	4,492,297	5,708,382	5,472,065	5,573,470	4,122,270	5,225,041	5,436,199	4,060,620
2013	4	5,332,799	4,778,475	5,820,451	4,327,208	4,492,297	5,708,382	5,472,065	5,573,470	4,122,270	5,225,041	5,436,199	3,911,853
2013	5	5,017,381	4,778,475	5,820,451	4,327,208	4,492,297	5,708,382	5,472,065	5,573,470	4,122,270	5,225,041	5,436,199	3,911,853
2013	6	5,017,381	3,978,719	5,820,451	4,327,208	4,492,297	5,708,382	5,472,065	5,573,470	4,122,270	5,225,041	5,436,199	3,911,853
2013	7	5,017,381	3,978,719	4,813,178	4,327,208	4,492,297	5,708,382	5,472,065	5,573,470	4,122,270	5,225,041	5,436,199	3,911,853
2013	8	5,017,381	3,978,719	4,813,178	4,772,933	4,492,297	5,708,382	5,472,065	5,573,470	4,122,270	5,225,041	5,436,199	3,911,853
2013	9	5,017,381	3,978,719	4,813,178	4,772,933	5,844,202	5,708,382	5,472,065	5,573,470	4,122,270	5,225,041	5,436,199	3,911,853
2013	10	5,017,381	3,978,719	4,813,178	4,772,933	5,844,202	4,616,779	5,472,065	5,573,470	4,122,270	5,225,041	5,436,199	3,911,853
2013	11	5,017,381	3,978,719	4,813,178	4,772,933	5,844,202	4,616,779	4,843,327	5,573,470	4,122,270	5,225,041	5,436,199	3,911,853
2013	12	5,017,381	3,978,719	4,813,178	4,772,933	5,844,202	4,616,779	4,843,327	3,715,368	4,122,270	5,225,041	5,436,199	3,911,853
2013	Total	61,470,245	51,743,404	######	######	59,315,184	######	64,407,304	######	49,467,242	62,614,973	66,620,652	47,388,537

Pls help me to solve the issue. If You can write the script in my document so much the better

Thanks in advance

topic Month Order in QlikView

Month Order