3 Replies Latest reply: Sep 22, 2017 8:08 AM by Sunny Talwar RSS

    Growth KPI's calculation on line chart for continuous years

    Kranthi Kumar Bhattu

      Hello Experts,

      Can some one please help in how to calculate Growth KPIs ( Year-1, Period -1, CAGR) in qlik sense expression.

      Following is my data schema , screen shot of visualization requirement  .

      Product YearSales
      A2010       4,83,39,016
      A2011       1,48,29,154
      A2012       1,42,73,602
      A2013       2,38,06,291
      A2014       8,34,01,655
      A2015       9,26,99,648
      A2016       8,13,40,752
      A2017       6,39,78,701

      Capture.PNG

      Thanks,

      Kranthi