topic Re: Sorting months chronologically in bar chart in QlikView

Sorting months chronologically in bar chart

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Sorting months chronologically in bar chart

sunny_talwar — Fri, 09 Dec 2016 01:31:22 GMT

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

Re: Sorting months chronologically in bar chart

trdandamudi — Fri, 09 Dec 2016 01:45:09 GMT

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...

Re: Sorting months chronologically in bar chart

Anonymous — Fri, 09 Dec 2016 14:05:56 GMT

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

Re: Sorting months chronologically in bar chart

Anonymous — Fri, 09 Dec 2016 14:06:32 GMT

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

Re: Sorting months chronologically in bar chart

sunny_talwar — Fri, 09 Dec 2016 14:09:53 GMT

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

Re: Sorting months chronologically in bar chart

Anonymous — Fri, 09 Dec 2016 14:15:09 GMT

Re: Sorting months chronologically in bar chart

sunny_talwar — Fri, 09 Dec 2016 14:16:35 GMT

Is your field name Calendar_Month or CalendarMonth?

Re: Sorting months chronologically in bar chart

Anonymous — Fri, 09 Dec 2016 14:28:55 GMT

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

Re: Sorting months chronologically in bar chart

sunny_talwar — Fri, 09 Dec 2016 14:32:05 GMT

Are you using my approach?

Date#(Month, 'MMMM')

trdandamudi‌'s approach?

Re: Sorting months chronologically in bar chart

Anonymous — Fri, 09 Dec 2016 14:36:11 GMT

Oh I see what the problem was, I just did your approach but changed it to CalendarMonth, instead of just Month. It worked!! Thank you so much!!!!!!!!!! I am very new to this and was just thrown into this project last minute, so I am learning everything as I go. You have been a huge help to me.

Re: Sorting months chronologically in bar chart

Fri, 09 Dec 2016 14:38:04 GMT

Are your months chronologically ordered when you make a listbox from the CalendarMonth ?

Re: Sorting months chronologically in bar chart

vishsaggi — Fri, 09 Dec 2016 14:40:06 GMT

I used to use the same approach as Thirumala mentioned above. You said Bad Field Name is your field name -> "Calendar_Month" has an underscore or just CalendarMonth ??

Re: Sorting months chronologically in bar chart

Anonymous — Fri, 09 Dec 2016 19:52:46 GMT

Hey Sunny-

On certain filters, there is zero data for some months. They are in chronological order now, but the months for where there is no data, they are at the end. I want to keep the zero value months, but i want them to appear in order. I also have a random blank spot after January that i need to remove. see attached.. see attached

Re: Sorting months chronologically in bar chart

sunny_talwar — Sat, 10 Dec 2016 01:21:23 GMT

Give this a try

Date#(Only({1} Month), 'MMMM')

Re: Sorting months chronologically in bar chart

Anonymous — Sat, 10 Dec 2016 17:41:51 GMT

That worked Sunny, but for some reason I still have a random blank spot at the end.

Re: Sorting months chronologically in bar chart

sunny_talwar — Sun, 11 Dec 2016 00:56:22 GMT

On the dimension tab, you can select 'Suppress When Value Is Null' and those blanks will go away

Re: Sorting months chronologically in bar chart

Anonymous — Sun, 11 Dec 2016 15:42:58 GMT

I have so much to learn. thank you.