Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
manu1512
Creator
Creator

Sorting month in Line chart

Hi all, I am creating a line chart in qliksense , but however x axis is month which is not getting sorted .

 

Can any one tell me how to do it.

PFA THE ATTACHED FILE

Labels (1)
2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

What sort option have you selected for this dimension?

-Rob

Claudiu_Anghelescu
Specialist
Specialist

if you don't have a MonthNum in order to order by MonthNum Asc you can use this in Expression Sort:

 

=match(only({1} Month), 'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')

To help community find solutions, please don't forget to mark as correct.