13 Replies Latest reply: Dec 30, 2015 3:55 AM by Andy Weir RSS

    Fiscal Year order - qlik sense

    Joanna Seldon

      Hiya

       

       

      I have this FiscalYear sorting code

       

       

      if ([Date Referred.Calendar.FiscalYear] = '2015' , 1,

                      if ([Date Referred.Calendar.FiscalYear] = '2014' , 2 ,

                                      if ([Date Referred.Calendar.FiscalYear] = '2013' , 3,

                                                      if ([Date Referred.Calendar.FiscalYear] = '2012' , 4 ,

                                                                      if ([Date Referred.Calendar.FiscalYear] = '2011' , 5 ,

                                                                                      if ([Date Referred.Calendar.FiscalYear] = '2010' , 6 ,

                                                                                                      if ([Date Referred.Calendar.FiscalYear] = '2009', 7, 8)))))))

       

      even I have done this sorting by expression...ascending and descending

       

      2015 always stays bottom of the list...need it to be at the top

       

      please help