% Year over year( YoY) growth without data for previous year

ajipaul03 — Sat, 16 Nov 2024 21:25:14 GMT

Hi All,

I need some expert advice on data representation relating to year over year growth.

Here is an example scenario

Customer	YR 2018	YR 2019	Change	% Change in 2019
A	100	90	-10	-10%
B	100	110	10	10%
C	0	300	300
D	20	0	-20	-100%
E	100	100	0	0%
F	50	10	-40	-80%
Total	370	610	240	65%

Even though there is 65% net increase in 2019 , the below chart gives an impression that 2019 is terrible . This is mainly because the value for C is missing ( for a valid reason ) .

So what is the ideal way to represent this chart to indicate that there is a significant growth ?or is there any way to indicate the zero to 300 growth for "customer C"

I definitely need the percentage . The above shown chart is part of my drill down. My actual scenario is much more complex than shown above.

Thanks,

Aji

Re: % Year over year( YoY) growth without data for previous year

pradosh_thakur — Wed, 13 Feb 2019 04:09:14 GMT

If it suits your requirement and the business is ready for this you can do the following for c .

so if the denominator is 0 then mathematically the calculation is not possible.If you consider the zero to be it's next number that is 1 then change would be 300%. So if the business is ok with this you can write a condition like

if(YR2018 =0  , YR2019-YR2018 % ,Your_change_expression)

you can write something similar to above.

topic Re: % Year over year( YoY) growth without data for previous year in QlikView

% Year over year( YoY) growth without data for previous year

Re: % Year over year( YoY) growth without data for previous year