Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikserbian
Contributor II
Contributor II

how to sort month jan dec in right way?

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,

7 Replies
mjayachandran
Creator II
Creator II

If you have timestamp or date,

then you can simply use =max(date)

or =max(timestamp) in your sort expression.

antoniotiman
Master III
Master III

Hi,

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

Regards,

Antonio

veeranj
Creator II
Creator II

Hi,

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

Thanks,

Anjee

veeranj
Creator II
Creator II

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
Contributor II
Contributor II
Author

I ve tried this one. Excellent. Works.

I will try other proposed solutions. Thank you all.

israrkhan
Specialist II
Specialist II

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...