topic Re: Cumulative expression on pivot table in QlikView

Cumulative expression on pivot table

berkarmagan — Fri, 06 Nov 2015 13:45:21 GMT

Hi,

I have a pivot table, year and month on pivot column, and i need cumulative sum(data) like the example below. When i use just sum(data) expression and pick Jan to May and 2015-2016 on list box the result is like the example 1, but i need a result like example 2, which is calculating cumulative by month and for just up to May for 2015 and also 2016. Is it possible? I tried range and above function but, it s getting complicated when I pick 2 years on list box. Thanks for now.

	2015					2016
	Jan	Feb	Mar	Apr	May	Jan	Feb	Mar	Apr	May
Product	10	20	25	20	10	20	20	10	15	10


2)
	2015					2016
	Jan	Feb	Mar	Apr	May	Jan	Feb	Mar	Apr	May
Product	10	30	55	75	85	20	40	50	65	75

Re: Cumulative expression on pivot table

lironbaram — Fri, 06 Nov 2015 14:19:26 GMT

this expression should do the trick for you

RangeSum(before( sum(SalesAmount) ,0,columnno(TOTAL)))

replace the sum(SalesAmount) with your expression

Re: Cumulative expression on pivot table

Gysbert_Wassenaar — Fri, 06 Nov 2015 14:21:25 GMT

That looks like a pivot table. Try using the Before() function instead of the Above() function.

Re: Cumulative expression on pivot table

berkarmagan — Fri, 06 Nov 2015 14:30:33 GMT

That worked, thanks 🙂