topic Re: Sorting a the Month Dimension in a Chart in QlikView

Sorting a the Month Dimension in a Chart

Thu, 19 Jun 2014 13:12:00 GMT

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,

Re: Sorting a the Month Dimension in a Chart

jerem1234 — Thu, 19 Jun 2014 13:16:15 GMT

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!

Re: Sorting a the Month Dimension in a Chart

swuehl — Thu, 19 Jun 2014 13:16:45 GMT

Just use the Month() function:

=Month(KeyDate)

and sort numeric

Re: Sorting a the Month Dimension in a Chart

Anonymous — Thu, 19 Jun 2014 13:25:53 GMT

Hi,

check this thread:

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

Re: Sorting a the Month Dimension in a Chart

Thu, 19 Jun 2014 13:29:25 GMT

Thanks guys

Amazed by the support I get in this community !