topic Re: Cumulative totals in QlikView

Cumulative totals

Wed, 03 Jun 2015 16:53:31 GMT

Hi Team,

Need your help in getting the cumulative totals in line chart.

I have years from 1920 to 2015. And my requirement is if i select year 2015 the line chart should display years 2015,2014,2013,2013 and the expression should display the accumulative totals from 1920.

ex for 2015 it should display sum of sales from 1920 to 2015 and for 2014 it should display sum of sales from 1920 to 2014.

Please help on this

Thanks

Nani

Re: Cumulative totals

Wed, 03 Jun 2015 17:01:13 GMT

sorry my mistake if i select year 2015 it should display 2015,2014,2013,2012

Thanks

Re: Cumulative totals

rakesh_kumar — Wed, 03 Jun 2015 17:01:26 GMT

Try something like this:

Sum({<Year= {">=Min(Date) <= ($=(Max(Year))"}>} Sales)

Re: Cumulative totals

maxgro — Wed, 03 Jun 2015 21:38:51 GMT

maybe

sum({$ <year={">=$(=max(year)-4)<=$(=max(year))"}>} aggr(rangesum(above(total sum({<year=>}sales),0,rowno())),year))

testdata:

load

1920-1 + rowno() as year,

1 as sales

AutoGenerate 96;

Re: Cumulative totals

ankit777 — Thu, 04 Jun 2015 06:22:02 GMT

Hi,

you can try something like this. PFA the QVW file. !

Re: Cumulative totals

Anonymous — Thu, 04 Jun 2015 06:27:01 GMT

Hi ,

you see use range sum to accumulate the values.

See below example of rangesum

Accumulative Sums

Thanks

BKC