Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
JohnSamuel123
Creator
Creator

how to correctly sort day/month on x-axis

hi,

i cant seem to get my x-axis to show correctly i.e. dates are in wrong places.

my x-axis:

JohnSamuel123_0-1648140753040.png

my sorting is set to auto, do i need to change it to custom and do a certain expression to get it showing the days in order?

i have two columns for my date for reference if needed:

JohnSamuel123_1-1648140893253.png

 

any ideas on how to get the right order on my x axis?

thanks!

 

Labels (2)
1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

 

Create your field as below and sort by numeric asc or desc order.

 Date(Datefield,'DD/MMM') 

or

 

Date(Datefield,'DD/MMM')  as Month_Day

or in the sort tab, use sort by expression and put =Month_Day in the expression field. Don't forget to select "Ascending".

View solution in original post

1 Reply
Chanty4u
MVP
MVP

 

Create your field as below and sort by numeric asc or desc order.

 Date(Datefield,'DD/MMM') 

or

 

Date(Datefield,'DD/MMM')  as Month_Day

or in the sort tab, use sort by expression and put =Month_Day in the expression field. Don't forget to select "Ascending".