how to do running totals?

[rmuhammad]

Hi All

I need help in doing running totals, my expression

sum({<[Term Type]=

,[Year/Month]=

,[Period]={">=$(=YearStart(Period))  <=$(=max(Period))"}

>} COUNT_Pop)

gives me monthly counts, how do I do running totals? Jan, jan+feb, jan+feb+mar, jan-apr so on

[shilpan]

Have you considered accumulation option?

[rmuhammad]

not sure why but it is grey out

[rmuhammad]

with the following expression i did get the cumulative sum however it is Nov - Jan , Nov to Feb and so on instead of Jan - Nov. Any ideas on how to reverse order

RangeSum (above(sum({<[Term Type]=

,[Year/Month]=

,[Period]={">=$(=YearStart(Period))  <=$(=max(Period))"}

>} COUNT_Pop),0,RowNo()))

[juraj_misina]

Hi,

you can use Below() function, which is similar to Above() but in reverse order (so in bottom up manner).

Juraj

[qlik4asif]

What is the Format of period.

Did you check Max(Period) format?