Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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'..

Tags (1)
6 Replies
Not applicable

Cummulative

Hi

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

Przemek

Not applicable

Cummulative

No. I need that in table.

MVP & Luminary
MVP & Luminary

Cummulative

Hi,

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

Regards,

jagan.

MVP & Luminary
MVP & Luminary

Re: Cummulative

Hi,

Hope the attached sample helps you.

Regards,

Jagan.

Re: Cummulative

Hi,

     Try with this expression.

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

Celambarasan

Not applicable

Re: Cummulative

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