6 Replies Latest reply: Jun 30, 2017 7:45 AM by Victor Torres Jurado RSS

    Cumulative value in the first element of a dimension

    Victor Torres Jurado

      Hello Experts,

      I'm trying to display some data for rolling 12 months, and the first month must include the value of its rolling 12 but I can't figure how to get it.

      Sample data:

      Sales:

      LOAD * INLINE [

          Month, Year, Sales, R12

          07, 15, 98127, 0

          08, 15, 70834, 0

          09, 15, 102456, 0

          10, 15, 92151, 0

          11, 15, 25420, 0

          12, 15, 15125, 0

          01, 16, 73453, 0

          02, 16, 23623, 0

          03, 16, 49325, 0

          04, 16, 696821, 0

          05, 16, 59686, 0

          06, 16, 268762, 0

          07, 16, 798165, 1

          08, 16, 8721312, 1

          09, 16, 546848, 1

          10, 16, 54231, 1

          11, 16, 218723, 1

          12, 16, 216787, 1

          01, 17, 363135, 1

          02, 17, 73781, 1

          03, 17, 845945, 1

          04, 17, 842907, 1

          05, 17, 953567, 1

          06, 17, 935689, 1

      ];

       

      R12 is the flag of Rolling 12

       

      So, I get these data

      screenshot_1.png

      But when I select the rolling 12 Months:

      screenshot_2.png

      Is there any way to get that the value of 07.16 could be 2.275.821?

      Thanks in advance.

      PS: I'm using Qlik Sense Desktop 3.2 SR4