topic Re: Sort by expression line chart is not working in Move to Qlik Cloud Analytics

Sort by expression line chart is not working

Punit — Tue, 27 Jan 2026 10:45:26 GMT

Hello All,

I am trying to show the current year vs last year's performance by month in a line chart.

However, when I select date range from mid 2022(say 1st May 2022) till last month(30th April 2023). It doesn't sort in chronological order, I already tried multiple ways.

Somewhere I read it works when sorted by Year, It did work for me the day I implemented it. But now as I see the chart its again back to same random pattern. Not sure if its an issue on Qlik side?

Please guide.

Re: Sort by expression line chart is not working

BrunPierre — Mon, 08 May 2023 14:18:57 GMT

Sort expression: =Month(Date#(MonthField,'MMM'))

Match(Only({1} MonthField)'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')

Re: Sort by expression line chart is not working

Punit — Mon, 08 May 2023 16:50:50 GMT

Still not working for me. Just to clarify date range selected is 1st May 2022 to 30th April 2023. I want the months to appear in sequence May, Jun, Jul, Aug, ..., Jan, Feb, Mar, April

But why would it be Oct, Apr, Jan.. as seen in the attached pic. It seems an issue with Qlik Saas.

Re: Sort by expression line chart is not working

BrunPierre — Tue, 09 May 2023 08:25:54 GMT

I get that you trying to sort considering the current month as the first.

=If(Month(MonthField)-Month(Today())<0, (Month(MonthField)-Month(Today())+12),(Month(MonthField)-Month(Today())))

Re: Sort by expression line chart is not working

MayilVahanan — Tue, 09 May 2023 08:57:01 GMT

Try to sort by MonthYear field or Date field.

Re: Sort by expression line chart is not working

Punit — Sun, 14 May 2023 08:06:35 GMT

Tried them, still not working.

not sure what wrong I am doing here.

Re: Sort by expression line chart is not working

VishalWaghole — Sun, 14 May 2023 09:12:59 GMT

Using Pick(Match()) try to generate seq. number as per your requirement, please use below script,

I have plotted May as 1st and Apr as 1 2 number of month using Pick(Match()) and used same field in sorting option under expression,

I hope it will work for you.

Thank You,

Vishal Waghole