7 Replies Latest reply: Feb 18, 2015 4:58 AM by Martin Sorel RSS

    Sorting in drill-down dimension not working

    James Kerrigan

      Hey guys,

       

      I've made a dirll-down dimension which drills down about 4 times berfore reaching the Financial Year dimension, and I can't seem to get the sorting working for a couple of the years, namely 2004/05 and 2005/06.

       

      qliksense example.png

      Inspecting the dimension shows that it should be in order, and when I put it at the top of the drill-down it is ordered correctly so I'm guessing it has something to do with the drill-down. Even more annoying is if I drill down once more to Periods, it's even more jumbled when I want it to go from 1-12. Again, if it's at the top of the drill-down it orders correctly.

       

      qliksense example2.png

      Currently the sorting is on automatic with the Dimension on the top, but no matter what I change it to I can't get anything to sort differently and I'm not familair with the sorting expressions.

       

      Does anyone know how to fix this?

       

      Edit: Sorry forgot to post, I don't think I'll be able to post the app.

       

      Message was edited by: James Kerrigan