Sorting months chronologically in bar chart

[Anonymous]

My source data has a column called "CalendarMonth" and the months are listed out: April, May, etc.

On my bar chart, they are going from left to right: March, October, November, July, January, May, April, August, September, June, February, December.

I just want them to go chronologically Jan-Dec. I tried searching these forums, but still not getting it to work. I am not sure this applies to me: How do I order months in a bar chart chronologi... | Qlik Community

[sunny_talwar]

Change your dimension to this

Date#(Month, 'MMMM')

and then sort numerically

or help qlikview understand your date field and then you won't have to worry about front end calculated dimension.

Date#(Month, 'MMMM') as Month

Read about date in QlikView here:

Why don’t my dates work?

Get the Dates Right

[trdandamudi]

One more solution you can try as below:

Go to Chart properties and then click on the Sort tab.

Under "Sort by" group un check everything except Expression

Select Ascending and paste the below fornula

Pick(Match(Calendar_Month,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'),1,2,3,4,5,6,7,8,9,10,11,12)

Hope this helps...

[Anonymous]

I get "bad field names" whenever I try any of these suggestions.

[Anonymous]

I get "bad field names" when i try this.

[sunny_talwar]

Would you be able to share more details as to where you are trying this? May be show some image?

[Anonymous]

[sunny_talwar]

Is your field name Calendar_Month or CalendarMonth?

[Anonymous]

Oh good catch, I removed the underscore. but the order still isnt right. see attached.

[sunny_talwar · Accepted solution]

Are you using my approach?

Date#(Month, 'MMMM')

or

trdandamudi‌'s approach?