2 Replies Latest reply: May 21, 2016 12:47 PM by Hari Babu RSS

    How to calculate Growth rate in Qlikview.

    Hari Babu

      I have used this expression to calaculate Growth rate. But i am not getting any answer in the text box.

       

      =num(((Sum({<[YYYYQQ]={$(=(vCurrentQuarter))}>}[Quantity])-Sum({<[YYYYQQ]={$(=(vPreviousYearQuarter))}>}[Quantity])))/(Sum({<[YYYYQQ]={$(=(vCurrentQuarter))}>}[Quantity])),'##0%' )

       

      I have defined the above variables

       

      Is there anything wrong in the expression?

       

      YYYYMMFinancial YearMonthQuarterYYYYQQQuantity
      2014112015NovQ12015Q1100
      2014122015DecQ12015Q1304
      2015012015JanQ12015Q1564
      2015022015FebQ22015Q2345
      2015032015MarQ22015Q2356
      2015042015AprQ22015Q2356
      2015052015MayQ32015Q3353
      2015062015JunQ32015Q3325
      2015072015JulQ32015Q3335