Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Cummulative measure

Hello,

question.PNG

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])

1 Solution

Accepted Solutions

Re: Cummulative measure

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())

11 Replies
martynlloyd
Contributor III

Re: Cummulative measure

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

Regards,

marty.

Re: Cummulative measure

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())

Re: Cummulative measure

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

Not applicable

Re: Cummulative measure

Thankyou very much, it works

Not applicable

Re: Cummulative measure

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

Re: Cummulative measure

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)

Not applicable

Re: Cummulative measure

More or less

It does this when is selected the year 2016

question2.PNG

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

Re: Cummulative measure

Have you already checked 'Suppressed Zero Values'?

Not applicable

Re: Cummulative measure

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