Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
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'}>} [ticket_id]), 0, RowNo())

View solution in original post

11 Replies
martynlloyd
Partner - Creator III
Partner - Creator III

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

Regards,

marty.

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'}>} [ticket_id]), 0, RowNo())

sunny_talwar

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

Not applicable
Author

Thankyou very much, it works

Not applicable
Author

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)

Not applicable
Author

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

sunny_talwar

Have you already checked 'Suppressed Zero Values'?

Not applicable
Author

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