topic Listbox sorting not working for an expression in QlikView

Listbox sorting not working for an expression

Mon, 24 Feb 2014 09:16:31 GMT

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 — Mon, 24 Feb 2014 09:23:00 GMT

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

preminqlik — Mon, 24 Feb 2014 09:24:06 GMT

hi once try the below exp in sort tab

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

Mon, 24 Feb 2014 09:27:34 GMT

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

Mon, 24 Feb 2014 09:27:47 GMT

Great, this works. Thanks!