12 Replies Latest reply: Jul 28, 2011 3:19 AM by Kaushik Solanki RSS

    sorting a time dimension

      hi guys, this is a follow-up from a previous discussion here http://community.qlik.com/message/136417#136417

       

      i currently am not sure how i can sort the fields in my cyclic group

       

      my cyclic group has these fields: year, quarter-year, quarter, month, week

       

      the charts look fine if u look at a single year, so the months will sort themselves numerically from 1 to 12 and quarter-year will appear from Q1-2011 to Q2-2011 and so on...

       

      however, if i choose 2010 and 2011, i see quarter-year Q1-2010 Q1-2011 Q2-2010 Q2-2011 Q3-2010 Q3-2011 Q4-2010 in this order...

       

      how can i make it appear in this order? Q1-2010 Q2-2010 Q3-2010 Q4-2010 Q1-2011 Q2-2011 Q3-2011

       

      the order does not change if i include the date field in the Sort tab under expression...