Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
MVP
MVP

Not for the dimension, but may be under the appearance

sunny_talwar
MVP
MVP

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

Capture.PNG