topic Re: Sorting mmm-yy dimension in QlikView

Sorting mmm-yy dimension

Thu, 14 Aug 2014 08:18:34 GMT

Hi,

I have a data load with the date format in mmm-yy. I have attempted to sort it in a variety of ways and not being successful. I am assuming i need to change the format? Can i do this in the expression part of the sort - or will it need to be done elsewhere and what will i need to do?

Thanks

James

Re: Sorting mmm-yy dimension

tresB — Thu, 14 Aug 2014 08:20:46 GMT

Try sort expression like:

=Date#(YourDateField, 'MMM-YY')

If this doesn't work , try to share your sample qvw.

Re: Sorting mmm-yy dimension

Miguel_Angel_Baeyens — Thu, 14 Aug 2014 08:20:58 GMT

James,

In those cases I always create a numeric, integer field in the calendar table that goes from 1 (first month in the calendar table) to n (last month in the calendar data), and then use this field in the Sort tab of the objects to sort by expression.

Another option, should that field is coming from a Date() function is that, given that it already has a numeric value, use it for sorting. If otherwise it's a string field where you just concatenate the month and the year, then the first solution of an extra field in the calendar table will do.

Miguel

Re: Sorting mmm-yy dimension

Thu, 14 Aug 2014 08:23:27 GMT

Hi,

Many thanks for that.....so simple! It has worked.

Thanks