2 Replies Latest reply: Oct 19, 2016 12:58 PM by Sunny Talwar RSS

    KPI Returns value from current and previous Year

    C�mara Municipal de Lisboa

      excel table.jpg

      Someone can give me a formula for previous year sum value, as shown in the pictures?

       

       

       

      qlikimage.jpg

      Current Year:

      Sum({$<[Date] = {">=$(=Yearstart(Max([Date])))  <= $(=Date(Max([Date])))"}>} value)

       

      Previous Year: ?