Month disordering !!

[nikhilgarg]

HEy,

I have used Month field and used a list box but my months are not coming in Jan-Dec order. They are coming in A-Z order.

What to do , please help.

Thanks

[sushil353]

Hi,

See if this can help you : Sorting in qlikview

HTH

Sushil

[sushil353]

Hi,

Also you can write in sorting > Exrpession

=Pick(Match(Monthfield,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec',1,2,3,4,5,6,7,8,9,10,11,12)

[sasikanth]

try to check the option

Load Order

if not

then use match function

Match(<Month-Field>,'Jan','Feb','Mar',............................)

in sort tab Expression

[nikhilgarg]

Hey ,

this doesnot works....

[nikhilgarg]

Hey,

MAtch function works but problem is Before jan it is showing July.

I mean:

July,Jan,Feb..... Jun , Aug....Dec

What to do now??

[sasikanth]

then please check the spell once in your backend make sure that same is there  in your expression

may be issue with cap/small letter

[nikhilgarg]

HEy,

I didnot get you. What you wana say ??

[sushil353]

Hi,

attach some screenshot or some sample data.

[deepakqlikview_123]

Go to Sort Tab

Select Month

Write below in expression =Date#(Month,'MMM')

now you can sort by Numeric Ascending or Descending Order