Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Month Sorting not working

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.

Labels (1)
2 Replies
Not applicable

Re: Month Sorting not working

Hi Sri,

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

@Sub2u

MVP
MVP

Re: Month Sorting not working

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.

Community Browser