Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ajipaul03
Contributor III
Contributor III

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

Hi All,

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

 

Here is an example scenario

CustomerYR 2018YR 2019 Change% Change in 2019
A10090-10-10%
B1001101010%
C0300300 
D200-20-100%
E10010000%
F5010-40-80%
Total37061024065%

 

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

 

 YoY Qlik.PNG

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

Labels (1)
1 Reply
pradosh_thakur
Master II
Master II

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.

Learning never stops.