topic Sort months in QlikView

Sort months

manisha_uit — Thu, 25 Aug 2011 10:29:08 GMT

Hi everyone,

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

Thanks

Manisha Choudhary

klausskalts — Thu, 25 Aug 2011 13:33:30 GMT

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

SunilChauhan — Thu, 25 Aug 2011 14:08:46 GMT

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

in same place write

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

thanks

Sunil

its_anandrjs — Thu, 25 Aug 2011 14:14:37 GMT

Hi,

Please refer this community thread.

Regards,

Anand