how to sort month jan dec in right way?

[qlikserbian]

Hi all,

for sure this is a simple question, but I need help. How to sort months in normal order jan feb mar apr may.... dec?

I tryed all sort options. is there any particular rule or just experience. In may excel file COLUMN month is formated as TEXT (JAN, FEB, MAR).

Thx,

[mjayachandran]

If you have timestamp or date,

then you can simply use =max(date)

or =max(timestamp) in your sort expression.

[antoniotiman]

Hi,

in Sort Tab -> Expression  = Month(Date#(MESEC,'MMM'))

Regards,

Antonio

[veeranj]

Hi,

IN sort tab, in expression ..give the condition as below.
match(month,'JAN','FEB','MAR',..........'DEC')

Thanks,

Anjee

[veeranj]

Hi,

IN sort tab, in expression ..give the condition as below.
match(month,'JAN','FEB','MAR',..........'DEC')

Thanks,

Anjee

[rubenmarin]

Expanding Veeranjaneyulu answer you can use

match(only({1} month),'JAN','FEB','MAR',..........'DEC')

so your months list keeps the order no matter the selections

[qlikserbian]

I ve tried this one. Excellent. Works.

I will try other proposed solutions. Thank you all.

[israrkhan]

Try sort expression as below

TRY INLINE TABLE ..

Load *,  INLINE

[

MESEC, SortOrder

JANUARY, 1

FEBRUARY, 2

MARCH, 3

APRIL, 4

MAY, 5

JUNE, 6

JULY, 7

AUGUST, 8

SEPTEMBER, 9

OCTOBER, 10

NOVEMBER, 11

DECEMBER, 12

];

THEN in the sort tab, just sort as number....will work...