5 Replies Latest reply: Nov 19, 2014 10:28 PM by Vishal Jada RSS

    Accumulation in the script level

    Vishal Jada

      Hi fellow qlikies,

       

      I'm trying to simulate accumulation function that is available in chart properties but in the script level.

       

      Month YearRegionSales
      Jan-14North100
      Jan-14East50
      Feb-14North20
      Feb-14South40
      Feb-14East30

       

      New aggregated Table

       

      Month YearRegionAggregated Sales
      Jan-14North100
      Jan-14East50
      Feb-14North120
      Feb-14South40
      Feb-14East80

       

      The bold rows indicate the effect of aggregation. In other words, in Feb-2014 North - > it takes the sales from jan-2014 and adds it to the sales in feb-2014. Same should follow for march where it would take the new sales from feb-2014 North (120) and adds it to the value for Mar-2014 North.

       

      Hope this makes sense. How can do this type of aggregation in QlikView?

       

      Any suggestions should help and thanks for your time.

       

      Regards

       

      Vishal