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.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
inmemoryofER
Contributor II
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)
0 Replies