# New to Qlik Sense

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

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save \$300 before February 6: REGISTER NOW!
cancel
Showing results for
Did you mean:
Contributor II

## Sort months on X-Axis of run chart starting with July (Fiscal Year)

I have a run chart with grouped months [month(ENCOUNTER_DATE)] on the X-axis. These months are sorted from January - December, but I would like to sort the X-axis starting with the first month of the fiscal year (July - June).  I tried sorting by an expression that explicitly redefined the order but this did not work:

`if(month(ENCOUNTER_DATE) = 7, 1, if(month(ENCOUNTER_DATE) = 8, 2,if(month(ENCOUNTER_DATE) = 9, 3, if(month(ENCOUNTER_DATE) = 10, 4, if(month(ENCOUNTER_DATE) = 11, 5, if(month(ENCOUNTER_DATE) = 12, 6, if(month(ENCOUNTER_DATE) = 1, 7, if(month(ENCOUNTER_DATE) = 2, 8, if(month(ENCOUNTER_DATE) = 3, 9, if(month(ENCOUNTER_DATE) = 4, 10, if(month(ENCOUNTER_DATE) = 5, 11,if(month(ENCOUNTER_DATE) = 6, 12))))))))))))`

Labels (2)

• ### Visualization

0 Replies
Tags
Community Browser