Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
YG
Contributor III
Contributor III

Qlik Sense - Change Line chart order of Quarters and rename them

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

YG_0-1606700958934.png

 

So I changed the order to descending

 

YG_1-1606701063565.png

 

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? 

 

 

Labels (4)
0 Replies