Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kylealpaugh
Contributor
Contributor

how to change week format on x axis of chart

is it possible to change the way the dates are formatted on a line chart right the chart goes back 365 days and is sorted numerically.

the only problem is that the current  year weeks 1-12 are listed first but i would like them listed last i would want it to go week 51,51,1,2 and so on is there any way that i can fix this.

Date chart.PNGSort.PNG

5 Replies
sasiparupudi1
Master III
Master III

May be change the sort order on the week dimension to numeric/descending?

krishna_2644
Specialist III
Specialist III

1.PNGCheck this out.

kylealpaugh
Contributor
Contributor
Author

how did you gt it to sort by 2 calendar years

krishna_2644
Specialist III
Specialist III

goto sorting tab --> click 'Week' --> Add expression 'num(WeekName(Date)) ' - this is for your case.

if this doesnt work for you, please see the doc that i've attached in my last reply.

sasiparupudi1
Master III
Master III

Or change the week sort to expression and choose your date field in there