Re: YoY Gorth in QlikSense for 3Years - Qlik Community

vikasmahajan · ‎2017-12-20

Hi all

I have attached sample excel sheet I wanted to create a line chart with Yoy Growth Analysis for 3 Years

Year Growth

2011 40 %

2012 25.1 %

2013 35.12 %

How to calculate and show in chart ?

Regards

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

SunilChauhan · ‎2017-12-20

(sum(Growth)/Above(sum(Growth))-1)

Sunil Chauhan

SunilChauhan · ‎2017-12-20

=If(GetSelectedCount(Year)=1,Sum(Growth)-Above(Sum(Growth))/Above(Sum(Growth))*100,Sum(Growth))

Sunil Chauhan

Gysbert_Wassenaar · ‎2017-12-20

You can use the Above function or use an AsOf table. See attached app.

talk is cheap, supply exceeds demand

vikasmahajan · ‎2017-12-20

Thanks Gysbert Wassenaar

I will check and come back you.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.