topic how to do running totals? in QlikView

how to do running totals?

rmuhammad — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: how to do running totals?

shilpan — Mon, 26 Feb 2018 21:32:37 GMT

Have you considered accumulation option?

Re: how to do running totals?

rmuhammad — Mon, 26 Feb 2018 21:39:01 GMT

not sure why but it is grey out

Re: how to do running totals?

rmuhammad — Mon, 26 Feb 2018 22:26:08 GMT

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

Re: how to do running totals?

juraj_misina — Mon, 26 Feb 2018 22:28:36 GMT

Hi,

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

Juraj

Re: how to do running totals?

qlik4asif — Tue, 27 Feb 2018 04:53:24 GMT

What is the Format of period.

Did you check Max(Period) format?