topic Listbox sort date MMMM YYYY in QlikView

Listbox sort date MMMM YYYY

Michaels — Wed, 09 Sep 2020 11:55:44 GMT

Hi,

I have a field Date formating like this : January 2019, February 2019, ...

I have a listbox with field and I would like to sort by decreasing date, I try with date#(Date, 'MMMM YYYY')

Data is correctly sort when there is no selection but when I select one date the other are group by month :

December 2020
December 2019

November 2020

November 2019

Any ideas ?

Thanks

sunny_talwar — Wed, 09 Sep 2020 12:17:46 GMT

Are you using this as your sort expression? date#(Date, 'MMMM YYYY'), may be try using this instead

Only({1} Date#(Date, 'MMMM YYYY'))

Michaels — Wed, 09 Sep 2020 12:22:39 GMT

It works ! Thank you !