Sorting month name

[Anonymous]

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.

[danieloberbilli]

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')   

[danieloberbilli]

[suresh_rawat]

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

[jagan]

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.

[ashfaq_haseeb]

Hi,

have a look at attached application.

Regards

ASHFAQ