Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
manisha_uit
Creator
Creator

Sort months

Hi everyone,

Can anyone help me to sort months in a proper order.

Thanks

Manisha Choudhary

3 Replies
klausskalts
Partner - Creator
Partner - Creator

If you use the Month([Date Field])-command to create your month it shoud sort correctly.

SunilChauhan
Champion
Champion

there are many ways to sort

load * inline [

Month,no

Jan,1

Feb,2

Mar,3

Apr,4

May,5

Jun,6

Jul,7

Aug,8

Sep,9

Oct,10

Nov,11

Dec,12

];

go to charts properties->sort-> seleect monthfied from leeft pane ->expression->no

or

in same place write

wildmatch(Monthfieldname,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')

thanks

Sunil

Sunil Chauhan
its_anandrjs

Hi,

Please refer this community thread.

http://community.qlik.com/message/144020#144020

Regards,

Anand