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

11 Replies
sunny_talwar

Not for the dimension, but may be under the appearance

sunny_talwar

My bad, it is under Add-ons -> Data handling -> Uncheck Show zero values

Capture.PNG