Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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:
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...
I get "bad field names" whenever I try any of these suggestions.
I get "bad field names" when i try this.
Would you be able to share more details as to where you are trying this? May be show some image?
Is your field name Calendar_Month or CalendarMonth?
Oh good catch, I removed the underscore. but the order still isnt right. see attached.