Month Order using slider and charts

[#1]

Hi all,

I'm relatively new to QlikView and I have an issue I need some help with.

If I use the slider in my dashboard to select say from Dec-11 to May-12 my chart displays the months in the folowing order Jan, Feb, Mar, Apr, May, Dec.  However, I need the Dec bar at the start.  Now, the problem is probably linked to my Year and Month List boxes but cannot think how (it's Friday afternoon and I am brain dead).  Can someone take a look at the attached image and tell me how I can get the months in the right order?

Many thanks all,

Matt

[MayilVahanan]

Hi,

     Try this,

      I think you use month as dimension, am i right? if so, in Chart properties -> choose sort -> select month in dimensions and give in load order -> original

Hope it helps

[#3]

Thanks for your response.  Your correct I am using month as the dimension.  but the sort >load order> original isn't working.... it may have something to do with the way I got the month in the first place which was like this (on the script):

Text(Month([Time Period])) as Month,

[MayilVahanan]

Hi,

     Why you give as Text(Month([Time Period])), you can simply use Month([Time Period]) AS Month..Both give the same result.For your requirement, second one is best solution i think.

Hope it helps

[#5]

Hi Mayil,  When I use the month{time period} as month, it pulls through the number rather than Jan etc.  But this is deviating away from the original issue (unles its the root cause?)

Many thanks,

Matt

[nagaiank]

If you are deriving month from a date field, you may use MonthName(Date) as dimension and this will sort the dimension correctly taking into account the month and year.

[#7]

Hi,

Thanks for your reply.  This does work, however, the new dimension includes the year (Dec 2011, Jan 2012, etc) whereas I only want the month displayed in the dimension (Dec, Jan, Feb, Mar).

Kind regards,

Matt

[nagaiank]

Try using Month(Date) as Dimension and MonthName(Date) as expression for sort order in the sort tab of the properties window