Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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,
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
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
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.
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
Try using Month(Date) as Dimension and MonthName(Date) as expression for sort order in the sort tab of the properties window