topic Re: Rolling 12 Month Chart - Month Sort Order in QlikView

Rolling 12 Month Chart - Month Sort Order

danielle_v — Sat, 16 Nov 2024 21:13:01 GMT

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.....

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

Re: Rolling 12 Month Chart - Month Sort Order

VishalWaghole — Tue, 19 Mar 2019 18:37:31 GMT

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

Regards,
Vishal

Re: Rolling 12 Month Chart - Month Sort Order

danielle_v — Wed, 20 Mar 2019 08:11:17 GMT

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!

Re: Rolling 12 Month Chart - Month Sort Order

VishalWaghole — Wed, 20 Mar 2019 12:33:52 GMT

Could you please share some sample data.

Re: Rolling 12 Month Chart - Month Sort Order

Madhab77 — Mon, 25 Apr 2022 12:41:19 GMT

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.