3 Replies Latest reply: Feb 16, 2018 10:36 PM by Lee Adoremos RSS

    Rainbow/Triangle Summation in Qlik Sense

    Lee Adoremos

      Hi Qlik Community,

       

      I would like to ask if you can suggest possible approach in achieving this kind of computation in Qlik Sense,

      This is an accumulative, that carries balance from OrigVal + Jan then carries that total forwarding the computation. It's like a Triangle summation. Any ideas or document reading is much appreciated.

       

       

      OrigVal + Jan

      OrigVal+ Jan + Feb

      OrigVal+ Jan + Mar

      OrigVal+ Jan + Mar + Apr

      OrigVal+ Jan + Mar + Apr + May

      OrigVal+ Jan + Mar + Apr + May + June

      OrigVal+ Jan + Mar + Apr + May + June + July

      OrigVal+ Jan + Mar + Apr + May + June + July + Aug

      OrigVal+ Jan + Mar + Apr + May + June + July + Aug + Sep

      OrigVal+ Jan + Mar + Apr + May + June + July + Aug + Sep + Oct

      OrigVal+ Jan + Mar + Apr + May + June + July + Aug + Sep + Oct + Nov

      OrigVal+ Jan + Mar + Apr + May + June + July + Aug + Sep + Oct + Nov + Dec

      OrigVal+ Jan + Mar + Apr + May + June + July + Aug + Sep + Oct + Nov + Dec + 13 +14+15+16

       

       

      Thank you