Cummulative measure

[#1]

Hello,

I want to create a measure T.Pendentes (the red one) that is the sum of the mesasure Pendentes (the yellow) on the previous years.

So it should be:

     68 on 2014

     68+132= 200 on 2015

     68+132+292=492 on 2016.

I don´t know if it help but at the moment the formula for the yellow measure is:

  Count(

          {

              $<status_name={

                  'new',

                  'open',

                  'pending reminder',

                  'pending auto close+',

                  'pending auto close-',

                  'approved',

                  'Waiting customer action',

                  'Waiting implementation Date',

                  'Verification in progress'

              }>

          }

      [ticket_id])

[martynlloyd]

Hi, just a thought, maybe accumulation will give you what you want?

Regards,

marty.

[sunny_talwar · Accepted solution]

Try this:

RangeSum(Above(Count({$<status_name = {'new', 'open', 'pending reminder', 'pending auto close+', 'pending auto close-', 'approved', 'Waiting customer action', 'Waiting implementation Date', 'Verification in progress'}>} [ticket_id]), 0, RowNo())

[sunny_talwar]

I don't think this option is available in Qlik Sense

[#5]

Thankyou very much, it works

[#6]

There is still one problem...

When I select the "Year" the graph changes for its original value.

For instance, if I select the Year 2016 it changes to 292.

I wanted that still show 492.

And for other years the same process

[sunny_talwar]

Try this:

RangeSum(Above(Count({$<status_name = {'new', 'open', 'pending reminder', 'pending auto close+', 'pending auto close-', 'approved', 'Waiting customer action', 'Waiting implementation Date', 'Verification in progress'}, Year>} [ticket_id]), 0, RowNo()) * Avg(1)

[#8]

More or less

It does this when is selected the year 2016

The only thing missing is, that the graph expand for the current selection

[sunny_talwar]

Have you already checked 'Suppressed Zero Values'?

[#10]

At the moment it as the "show nulls value" not selected. and it doesnt change if I select