Listbox sorting not working for an expression

[#1]

Hi,

I have a date field in my data, format is 'YYYYMM'.

I would like to show like this in my filter list box: 'MM/YYYY'

First issue when not selecting a value: the value 06/3014 is on top, where  I would expect it to be the last entry. The rest looks fine.

The real problem occurs as soon as I select a value:

1.) The order is completely messed up in the Expression list box. How can I correct it?

2.) Why is '201304' the first deselected value in the original value list box, although this is the previous value?

Thanks,

Jens

[alexandros17]

Go in sort tab and use the same expression in the expression textbox (check it before)

[preminqlik · Accepted solution]

hi once try the below exp in sort tab

only({1}date(date#(TransDate,'YYYYMM'),'MMYYYY'))

[#4]

That doesn't work for me, sorry. It is the same result.

[#5]

Great, this works. Thanks!