Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vikasmahajan
Honored Contributor III

YoY Gorth in QlikSense for 3Years

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

4 Replies
chauhans85
Esteemed Contributor

Re: YoY Gorth in QlikSense for 3Years

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

chauhans85
Esteemed Contributor

Re: YoY Gorth in QlikSense for 3Years

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

Re: YoY Gorth in QlikSense for 3Years

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


talk is cheap, supply exceeds demand
vikasmahajan
Honored Contributor III

Re: YoY Gorth in QlikSense for 3Years

Thanks Gysbert Wassenaar

I will check and come back you.

Vikas