topic Re: cumulative growth in QlikView

cumulative growth

yogitamehta10 — Fri, 17 Nov 2017 16:10:54 GMT

Has someone tried cumulative growth in Qlikview ..

like example. sample formula and output is attached in excel

Re: cumulative growth

yogitamehta10 — Fri, 17 Nov 2017 21:10:41 GMT

swuehl‌

tresesco‌ Any help ?

Re: cumulative growth

tresB — Mon, 20 Nov 2017 06:37:21 GMT

Could you explain the logic of your calculation?

Re: cumulative growth

yogitamehta10 — Mon, 20 Nov 2017 07:58:11 GMT

‌logic is there in attached excel file ..

Re: cumulative growth

yogitamehta10 — Mon, 20 Nov 2017 08:08:26 GMT

‌stalwar1‌.. Your input will be appreciated

Re: cumulative growth

yogitamehta10 — Mon, 20 Nov 2017 08:12:37 GMT

‌if you see excel file growth wou be some of all the values and cumulative growth would be p1Ly -p1Ly / p1Ly and for next is the output of that + p2CY-P2Ly/P2LY and so on till 12 months

Re: cumulative growth

tresB — Mon, 20 Nov 2017 08:37:45 GMT

I see two year columns. And also it would be easy for me if you could write excel formula to derive the data.

Re: cumulative growth

yogitamehta10 — Mon, 20 Nov 2017 10:49:05 GMT

column

Growth

Cumulative Growth

Period

Year

Growth

Cumulative Growth

P01

2016

30%

C15-C12/C15

P02

2016

-25%

C15-C12/C15+C16-c14/C16

P03

2016

18%

-4%

C15-C12/C15+C16-c14/C16+C18-C15/C18

P01

2017

130

P02

2017

P03

2017

130

Re: cumulative growth

sunny_talwar — Mon, 20 Nov 2017 11:12:43 GMT

May be something along these lines

(RangeSum(Above(Sum({<Year = {2017}>}NSV), 0, RowNo())) -

RangeSum(Above(Sum({<Year = {2016}>}NSV), 0, RowNo()))) /

RangeSum(Above(Sum({<Year = {2017}>}NSV), 0, RowNo()))

Re: cumulative growth

yogitamehta10 — Mon, 20 Nov 2017 16:47:22 GMT

Sorry my formulas are like this ..

column	Growth	Cumulative Growth
12	Period	Year	Growth	Cumulative Growth
13	P01	2016	100	30%	C16-C13/C13
14	P02	2016	120	0%	(C16+C17)-(C13+C14)/(C13+C14)
15	P03	2016	110	-4%
16	P01	2017	130
17	P02	2017	90
18	P03	2017	130	#VALUE!
Basically Ly -Cy/Cy and then for Next period we will add the values in formula.. And it will keep on going.

Re: cumulative growth

sunny_talwar — Mon, 20 Nov 2017 16:49:02 GMT

okay, so what I gave you didn't work?

Re: cumulative growth

yogitamehta10 — Wed, 22 Nov 2017 16:15:25 GMT

That helps ..Thankyou so much.