Month Sorting order in Multi Box

[grakeshqvd]

Hi All,

How to get Month_Year Sorting order in Qlikview multibox Expression.

Suppose Fileld Name like Month_Name:

Month_Name

Apr_2018

Jun_2018

Nov_2017

Feb_2018

Sep_2017

May_2018

Dec_2018

Mar_2018

Jan_2018

Oct_2017.

I need to show Drop down list like this in multi box:

Month_Name

Jun_2018

May_2018

Apr_2018

Mar_2018

Feb__2018

Jan_2018

Dec_2017

Nov_2017

Oct_2017

Sep_2017.

Thanks

[tamilarasu]

Hi Rakesh,

[grakeshqvd]

Thanks.  Will try

[MarcoWedel]

try loading your Month_Name field as proper Date (Dual value containing numerical part):

Get the Dates Right

hope this helps

regards

Marco