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: 
danielle_v
Creator
Creator

Rolling 12 Month Chart - Month Sort Order

Hello,

I have a line chart that shows year on year volumes for a rolling 12 month period (based on user date selections) vs. the previous 12 month period. As per the below screenshot, the user has selected Feb-18 for the calendars so the chart is showing Mar-16 to Feb-17 vs. Mar-17-Feb-18. This is working as expected, however I can't get the chart sort order to work correctly. I want the order to be dependant on the users selection, so in the case below I would want the axis to be sorted from Mar -Feb.

I have used the following expression to try and sort the order, but as you can see form the screenshot, this hasn't worked as expected;

=if(Cal_Month = 'Feb', match(Cal_Month, 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec', 'Jan', 'Feb')) etc.....

Capture 190319.PNG

Is anyone able to point mw in the right drection with this please?

 

Labels (6)
4 Replies
VishalWaghole
Specialist II
Specialist II

Could you please try to sort it using date, from which you derived MonthYear.

Regards,
Vishal
danielle_v
Creator
Creator
Author

Hi Vishal,

Thanks for your response

I have tried putting the Cal_MonthYear field into the sort by expression box, but this seems to behave exactly as per the above screenshot. I really don't know what to try now!

 

VishalWaghole
Specialist II
Specialist II

Could you please share some sample data.
Madhab77
Contributor III
Contributor III

Hi Danielle,

Thanks for posting query. Similar issue I am facing. Did you get any solution for this. If so, please reply here or can write me to madhab77@gmail.com

 

Thanks & Regards,

Madhab Sikder.