topic Sort Month and Year in Order in QlikView

Sort Month and Year in Order

Tue, 13 Dec 2011 18:37:09 GMT

Hi,

My file is loaded in this order(MMM YYYY) for 2010 and 2011. How do I sort this in order? Also, when I select 2010/2011 all the months start jumping around in my graphs.

APR 2010 MAY 2010

APR 2011 MAY 2011

AUG 2010

AUG 2011

JAN 2010

JAN 2011

Thanks for the help!

Sort Month and Year in Order

Sokkorn — Wed, 14 Dec 2011 04:04:49 GMT

Hi samantham,

Any small application then would be understand well on your issue. If have any attachment then it would be easy to find solution.

Regards,

Sokkorn Cheav

Sort Month and Year in Order

Anonymous — Wed, 14 Dec 2011 04:41:47 GMT

Dear Samantham

its better to find use function monthname(order#(Apr 2011,'MMM YYYY')) and then sort it into Ascending or descending

by ticking on the numeric sort in sort tab

do let me know wether it worked

else u can also use

Exp num(makedate( year(order#(Apr 2011,'MMM YYYY')),Month(order#(Apr 2011,'MMM YYYY')),01))

in ur sort tab it will solve ur problem

do let me know wether it worked

Thnxs

Sachin.S

Sort Month and Year in Order

kamalqlik — Wed, 14 Dec 2011 04:41:51 GMT

Hi Samantham the problem with your output is that ...you are getting the date as String format not as the date format.

So you are getting the desired result.First get the date in no format. for example for the field

Orderdate it may be----date(orderdate,'DD/MM/YYYY') as orderdate1

then fin the

min(orderdate1)

then make a variable $MinDate using the peek function

date(monthstart($(vMinDate) + rowno() - 1), 'MMM-YYYY') AS MonthYear.

This will give you the required result.

Hope this will help you.

If any further query than give the attached copy of your application

regards

Kamal

Re: Sort Month and Year in Order

Sokkorn — Wed, 14 Dec 2011 05:05:03 GMT

Hi samantham,

Right Click on Chart ==> Sort tab ==> Select on Dimension ==> Check on Expression and past this Match(CAPITALIZE(LEFT(TRIM(Months),3)), $(=chr(39) & Replace(MonthNames, ';', chr(39) & ',' & chr(39)) & chr(39))) + (RIGHT(TRIM(Months),4) * 10)

See the attached file also.

Note: Months is the field in format (MMM YYYY).

HTH and let me know.

Regards,

Sokkorn Cheav

Re: Sort Month and Year in Order

Fri, 18 Sep 2015 09:59:25 GMT

Hi ,

Can you help be modify our expression if the Month is in the format MMM-YY?

Thanks

Khushboo