topic Month Sorting not working in QlikView

Month Sorting not working

Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I have a month field as "MMMYY" in one of the Dashboard which is used in listox, multibox objects, I have moved the same Dashboard to the Development, Testing and Production environment, the month field is getting sorted properly in the Development & Testing, but its not sorting in the Production environment, experts please suggest me on this, what could be the possible issue for not sorting in production. this issue started after some data updated in the database.

Re: Month Sorting not working

Wed, 28 Jan 2015 02:27:45 GMT

Hi Sri,

Please check with List Box Properties > Sort > [] Numeric Value (Enable) > Ascending Order..

@Sub2u

Re: Month Sorting not working

jagan — Wed, 28 Jan 2015 04:11:05 GMT

Hi,

Make sure that your Month field is arrived like below

LOAD

Date(MonthStart(Date), 'MMMYY') AS Month

FROM DataSource;

and in listbox properties -> Select -> Numeric Ascending

Hope it helps you.

Regards,

Jagan.