How to fix order in a list box

[#1]

Hi ,

I have a list box which sorted by "Expression".

"Expression is the only check-box checked, and the expression is

=match(MES,'ene','feb','mar','abr','may','jun','jul','ago','sep','oct','nov','dic')

When there is no month (spanish) selected, the list box is correctly ordered but when there is one selected month the selected one goes to the end or to the beginning of the list.

I would like it remains ordered as it was.

Thanks.

[PrashantSangle]

Hi,

go to property-> select sort tab->uncheck all options

Resize your list box to full data

Regards,

[MK_QSL]

Convert your MES as below

Month(Date(Date#(MES,'MMM'),'MMM')) as MES

Now in Sort tab of list box

Don't select Numeric Ascending Order

[maxgro]

this seems to works

=wildmatch(only({1} Regione), 'Liguria', 'Lombardia', 'Piemonte', '*')

so in your case should be

=match(only({1} MES),'ene','feb','mar','abr','may','jun','jul','ago','sep','oct','nov','dic')

[preminqlik]

Hi there,

use this expression in sort expression

=only({1}match(MES,'ene','feb','mar','abr','may','jun','jul','ago','sep','oct','nov','dic'))

Hope this helps !

@

Premhas

[#6]

Hi,

use this expression in sort expression

=avg({1}match({1}match(MES,'ene','feb','mar','abr','may','jun','jul','ago','sep','oct','nov','dic'))

Hope this will  works !!

[Anonymous]

create a inline table with the field name and sort order (numeric) and link the field with main field and reload the app

and after that  drop the inline table and do a reload again

Hope it helps

Sri

[#8]

Earlier, easier correct answer.

Thanks