Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
rmuhammad
Creator
Creator

how to do running totals?

Hi All

I need help in doing running totals, my expression

sum({<[Term Type]=

,[Year/Month]=

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

>} COUNT_Pop)

running total.png

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

5 Replies
shilpan
Luminary Alumni
Luminary Alumni

Have you considered accumulation option?

rmuhammad
Creator
Creator
Author

not sure why but it is grey out

running total.png

rmuhammad
Creator
Creator
Author

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

running total.png

juraj_misina
Luminary Alumni
Luminary Alumni

Hi,

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

Juraj

qlik4asif
Creator III
Creator III

What is the Format of period.

Did you check Max(Period) format?