Listbox

[rathnam_qv]

Hi all,

i have list box like Jan to Dec.....but it is not in correct order.i want to display it like JAN,FEB,MAR.....DEC

help me...

Thanks!!!

Smiley

[Anonymous]

Change Sort order to Numeric, or to Load Order.

Jonathan

[jvitantonio]

That depends on the type of field. In your case, it might be a simple string field. In your script, create a dual field like:

Load

dual(MonthName, MonthNumber) as Month

From...

Where MonthName is the field containing the month name and Month number is the month number.

Dual will allow you to see the month name but behind it, it will behave as a number, making sorting easy to implement.

[rathnam_qv]

hey still it is not happening...

[kaushiknsolanki]

Hi,

     Create an inline table something like below.

     Inline:

     Load * inline [

     Month, MonthSort

     JAN,1

     FEB,2

     Mar,3

     ..

     ];

     Make sure that the Month field name links with your month field in data model.

     Now go to the listbox properties- > Sort ->Select Expression ->Type MonthSort.

Regards,

Kaushik Solanki

[#6]

try this

LOAD *,

month(date(date#(field,'MMM'),'MMM')) as month

INLINE [

    id, price, field

    1, 2, Jan

    2, 3, May

    3, 0,Mar

    4, 5,Apr

    5, 1,Feb

];