topic sorting month in QlikView

sorting month

Wed, 22 Dec 2010 07:16:31 GMT

I want to sort month ( in text format) but am not sure how to do it. I read many posts but was not able to figure out how to do it.

Loading order could be anything but finally sorting order should be as per calendar.

Can someone please help?

sorting month

sunil2288 — Wed, 22 Dec 2010 07:44:42 GMT

Hi naveen,

You can use like this using inline function.

LOAD * INLINE [
Month, Value,
Jan, 1
Feb, 2
mar, 3
Apr, 4
May, 5
Jun, 6
July, 7
Aug, 8
Sep, 9
Oct, 10
Nov, 11
Dec, 12
];

Hope this will help you.

Thanks

Sunil

sorting month

Wed, 22 Dec 2010 07:59:46 GMT

thanks for the reply Sunil

Can you please help where should i put this code?

sorting month

sunil2288 — Wed, 22 Dec 2010 08:02:23 GMT

Hi naveen,

Put this code in the Edit Script command editor. Where u normally write the load script commands.

Thanks.

SUnil

sorting month

Wed, 22 Dec 2010 08:50:14 GMT

thanks it worked....Only thing to note is that the column name should be same in this code and with the master table which one should use for linking.

AW:Re: sorting month

martinpohl — Wed, 22 Dec 2010 09:28:14 GMT

so rename the field Month in the inline load statement to your month-field-name.

Regards

sorting month

Thu, 02 Feb 2012 13:45:52 GMT

This is how this issue was resolved

I think this is converting the text to Date format which is then helping me to sort by month and year

date(date#([Fill Position Month],'MMM-YYYY'),'MMM-YYYY') as "Fill Position Month",