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

Hi,

I need help on cummulative.

Eg.

Amount
Cummulative Amount
11
23
36
410
515

Can anybody please tell the syntax to calculate 'Cummulative Amount'..

6 Replies
Not applicable
Author

Hi

If you need that in chart you can use acummulation settings in chart preferences (Expressions tab).

Przemek

Not applicable
Author

No. I need that in table.

jagan
Luminary Alumni
Luminary Alumni

Hi,

If you are using Straight table try using the Full Accumulation in Expression tab.

Regards,

jagan.

jagan
Luminary Alumni
Luminary Alumni

Hi,

Hope the attached sample helps you.

Regards,

Jagan.

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Try with this expression.

     =Sum(Amount) + Alt(Above([Cummulative Amount]),0)

Celambarasan

Not applicable
Author

This is the expression that I use in my Chart. I have Set analysis filtering a Cost type to Obligated, so its possible.

=RangeSum(above(Sum({$<[Cost Type]={"Obligated*"}>}Amount),0, rowno()))


No set analysis:

RangeSum(above(Sum(Amount),0, rowno()))