Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sorting a the Month Dimension in a Chart

Hello,

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

Sample.png

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,

1 Solution

Accepted Solutions
jerem1234
Specialist II
Specialist II

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!

View solution in original post

4 Replies
jerem1234
Specialist II
Specialist II

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

Just use the Month() function:

=Month(KeyDate)

and sort numeric

Anonymous
Not applicable
Author

Not applicable
Author

Thanks guys

Amazed by the support I get in this community !