2 Replies Latest reply: Sep 19, 2011 6:15 AM by jeevaguru RSS

    Fiscal YTD & Cal YTD

      How can we achieve fiscal YTD & Cal YTD in QlikView. Can Anyone Explain?

       

      Regards,

      Jeeva.

        • Fiscal YTD & Cal YTD
          Arunesh Gupta

          The below fiscal year conversion code : note here fiscal year started from July

          if( num(Month(OrderDate))>6,Year(OrderDate)+1,Year(OrderDate)) as FiscalYear, // Converting Year in Fiscal year

           

          'Q' & Ceil(If(num(Month(OrderDate))<=6,Right('00'&num(Month(OrderDate)+6),2),Right('00'&(num(Month(OrderDate))-6),2))/3) as FiscalQuarter, // Converting Quarter in Fiscal Quarter

           

          If(num(Month(OrderDate))<=6,Right(num(Month(OrderDate)+6),2),Right((num(Month(OrderDate))-6),2))as FiscalMonth,// Converting Month in

          Fiscal Month

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

           

          =sum({$<FiscalYear = {$(=max(FiscalYear))}, FiscalMonth = {"<=$(=max({<FiscalYear={$(=max(FiscalYear))}>} FiscalMonth))>"}>} Sales*vCurrency)/1000

           

           

           

           

          YTD: