Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
ASKI
Contributor
Contributor

Order to september 2021 to august 2022 in line chart

Hello,

I'm new to Qlik sense and i need some advice about the line chart graph.

I have a dimension "date.month", my dimension looks like "jan., feb. etc.." of year N but I want it to look like sept. to dec. year N and jan to aug. year N+1

Graph.PNG

For now, I succeed to do this but my values from january to august are not values of the year N+1

Regards,

 

 

Labels (6)
1 Reply
Or
MVP
MVP

I'd suggest using the MonthName() rather than Month(). In the autocalendar, I believe this is called YearMonth. It includes both the year and month components which means it will order it chronologically, rather than by month number.