Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
mdb_blin
Contributor
Contributor

YearWeek in chronological order in a barchart

I am filtering by last 4 months(Nov-2018 to Feb 2019) which crosses into 2018. 

I am trying to get my bar chart to view week in chronological order?  Anyway to do this without having to affect the script?

I want it to show from Week 40(Nov 2018) and ending at Week 9 (Feb 2019).

Currently, it begins at Week 1.

 

 

2 Replies
settu_periasamy
Master III
Master III

Hi,

Did you try to give the 'Expression' in the sort tab?

Capture.JPG

crusader_
Partner - Specialist
Partner - Specialist

Hi,
Try to use "Sort by Expression" and expression will be something like
Year*100+Week

Assuming both year and Week are numbers
Hope this helps!
//Andrei