Hi Qlikers,
I seems to be having an issue with below graph as my company Quarters are different to Qlik standed Q1 toQ4
My first Quarter starts from = 1 Oct
but my current graph
So I changed the order to descending
But report readers are confused now saying that we are not in Q4 but we are in Q1
I did use for monthly order change using below calculation,
=Match(Mid([Opened.autoCalendar.Month],1,3), 'Oct','Nov','Dec','Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep')
But still my graph looks confusing.
What I want to know is, How do I change/Rename the
Q4 as Q1
Q3 as Q2
Q2 as Q3
Q1 as Q4
in X Axis and have this report simplified?