1 Reply Latest reply: Jan 13, 2013 6:35 AM by Nagaian Krishnamoorthy RSS

    Need Help

    Shantnu Patel

      i have to calculate  view for months for this i have to subtract views for priviouse month from current month.

      Raw Data:

      TypeJanFebMarAprMay
      abc10001060112011801240
      bca20002040208021202160
      cab30003070314032103280
      ghy40004020404040604080
      ghj50005080516052405320
      rty60006090618062706360
      hio70007020704070607080
      hdo80008010802080308040
      gft90009025905090759100

       

      calculation:

       

      View(Jan)View(Feb)View(Mar)View(Apr)
      60606060
      40404040
      70707070
      20202020
      80808080
      90909090
      20202020
      10101010
      25252525

      like for Jan view = Feb-jan

      for Feb view= Mar-Feb

      ...................

       

       

      Please suggest how to do this at time of loading or in expression in qlikview line chart and table.