Sorting a the Month Dimension in a Chart

[#1]

Hello,

I have a chart which is meant to show Dimension - Month Names and the measures. shown below

I am using a Field Called KeyDate (a number) and using a calculated Dimension =Text(Date(KeyDate,'MMM')) which returns the Month.

I don't want to use the function Month Name as I don't want the Year appended after the month E:g I want Jan instead of Jan 2014. The reason being Series 1 is for Year 2014 and Series 2 is for Year 2013.

Now the problem is that when I use the above function QV is sorting them as

Dec, Jan, Feb .... Nov

I have tried using Sort by Numeric and that doesn't seem to do the trick. I also tried using Sort by expression where my expression is

Month(KeyDate) which I expect would return an integer for the month. No luck.

Any thoughts and advise would be appreciated.

Thanks,

[jerem1234 · Accepted solution]

It's because you are using text around the date, which is stripping the number off of it. Why not just use:

Month(KeyDate)

as your calculated dimension? It will return months like Jan, Feb, Mar, etc. Which is the same format you want, but yet retains the dual format of a date.

Hope this helps!

[swuehl]

Just use the Month() function:

=Month(KeyDate)

and sort numeric

[Anonymous]

Hi,

check this thread:

http://community.qlik.com/thread/12164

[#5]

Thanks guys

Amazed by the support I get in this community !