5 Replies Latest reply: Jun 13, 2018 7:09 AM by Sunny Talwar RSS

    how to sort Financial Year in Qlik sense manually by expression

    vikas mahajan

      Hi All,

       

      I manage sorting for months & Quarters by expression in qlik sense using following expression

       

      if( $(vSalesView) = 1, MonthNumber,if($(vSalesView) = 2,Match(Quarter,'Q1',  'Q2', 'Q3', 'Q4'),

      if($(vSalesView) = 3,FinancialYear)))

       

      But for financial year chart is not sorting .Financial Year Sort Manually.png

      Does any one sort by financial year wise ?

       

      vikas