topic Sorting month name in QlikView

Sorting month name

Anonymous — Tue, 28 Oct 2014 03:02:39 GMT

Type	Month
a	August
b	September
c	September
d	September
e	September
f	September
g	October
h	September

Can someone help me on how to sort the month?

Qlik view sort show August,October,September.

I want it to sort like August,September,October.

Please help me. Thank you.

Re: Sorting month name

danieloberbilli — Tue, 28 Oct 2014 03:29:52 GMT

QV does not know that the field 'Month' is actually a date field. A short (but dirty) solution would be an expression in a listbox: =date#(Month,'MMMM')

Re: Sorting month name

danieloberbilli — Tue, 28 Oct 2014 03:32:39 GMT

Re: Sorting month name

suresh_rawat — Tue, 28 Oct 2014 04:21:13 GMT

Hi,

For Sorting the month names...first save this file in a QVD then use this QVD and apply Dual Function on Month Field.

Hope this will help you.

Regards

Suresh Rawat

Re: Sorting month name

jagan — Tue, 28 Oct 2014 04:22:32 GMT

Hi,

In script try like this

LOAD

Date(Date#(Month, 'MMMM'), 'MMMM') AS MonthSort

FROM DataSource;

Now use this dimension in chart and select Numeric in Sort tab.

Regards,

Jagan.

Re: Sorting month name

ashfaq_haseeb — Tue, 28 Oct 2014 05:11:06 GMT

Hi,

have a look at attached application.

Regards

ASHFAQ