topic Re: Month Order using slider and charts in QlikView

Month Order using slider and charts

Fri, 06 Jul 2012 13:15:19 GMT

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

Re: Month Order using slider and charts

MayilVahanan — Fri, 06 Jul 2012 13:23:55 GMT

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

Re: Month Order using slider and charts

Fri, 06 Jul 2012 13:27:46 GMT

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,

Re: Month Order using slider and charts

MayilVahanan — Fri, 06 Jul 2012 13:30:49 GMT

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

Re: Month Order using slider and charts

Fri, 06 Jul 2012 13:33:54 GMT

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

Re: Month Order using slider and charts

nagaiank — Sun, 08 Jul 2012 21:18:32 GMT

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.

Re: Month Order using slider and charts

Mon, 09 Jul 2012 08:25:43 GMT

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

Re: Month Order using slider and charts

nagaiank — Mon, 09 Jul 2012 12:02:28 GMT

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