6 Replies Latest reply: Jun 26, 2017 2:35 PM by Sunny Talwar RSS

    How to create a accumulated results by product in a straight table from expression?

    Leandro Duarte

      Dear Colleagues, I'm trying to get a accumulated results that depends on the Product in a straight table but based on expression and not dimension.

       

      Please see below one table with the example of expected results (last column)

      model.png

       

      I have tried to use above and it stop to accumulated when the week change. For RangeSum it accumulate all the period and not by product and the problem it doesnt work for expression.

       

      I appreciate if somebody can give a good idea to share. I have added the Qlikview as example enclosed.

       

      Thanks
      Leandro