Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Discussion Board for collaboration related to QlikView App Development.
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?