5 Replies Latest reply: Aug 7, 2018 8:23 AM by Sunny Talwar RSS

    Ignore one dimension in above function

    Virilo Tejedor

      Hi,

       

      I'd like to plot a chart with a cumulative sum over time, and split it into groups (one cumulative sum per group)

       

      I tried a line chart with two dimensions FEC_PETICION (date) and BALANCE_GROUP_DESC (group description string)
      And the next measure:

       

      Rangesum(
      above(Sum({$<ERROR={0}>}[BALANCE_FACTOR]),
              0,
              vMaxDays
          )
      )

       

      It's not working because the BALANCE_GROUP_DESC is interfering the cumulative sum.

       

      I'd tried the next, but QlikSense doesn't allow exceptions to TOTAL clause for above function ¿?

       

      Rangesum(
      above(TOTAL<FEC_PETICION> Sum({$<ERROR={0}>}[BALANCE_FACTOR]),
              0,
              vMaxDays
          )
      )

       

      How could I ignore the date FEC_PETICION for cumulative sum, but use it to draw separately each cumulative sum into groups?

       

      A sample application is attached.

       

      TIA,

       

      Virilo