Expression for cal CGAR ?

[paulyeo11]

HI All

i have attend the meeting  last 20 year , I keep see people present their sales growth over the year . assume that  company operate for last 10 year , and first  sales 1 million and 2nd year 2 million and 10 year later this year in 2015 10 million sales.

may I know the expression for CGAR ?

Paul

‌

[paulyeo11]

Hi Sunny

Thank you for share with me the link , i notice that you are the one who wrote the document. I am still not able to apply you expression , because my data structure are different from your sample QVW.

Paul

[sunny_talwar]

Can you throw in some sample data which shows how your data is structured?

[paulyeo11]

Hi Sunny

I have attach my QV doc when i reply QlikView 7799 post.

Paul

[sunny_talwar]

Oh right, did not look at that. Will check it out now

[paulyeo11]

Hi All

The QVW file last night i upload is very complicated , This time i try to upload the simple one.

Hope some one can advise me how to get the value of CAGR for 2010 till 2015.

Paul

[prma7799]

Hi Paul,

Try to convert my fields with your existing fields.

Here I am not able to open your QVW.

Thanks

[paulyeo11]

Hi QV 9977

I just upload a new QV doc ver 007

Can you pls take a look sure can open

Paul

Sent from my iPhone

[prma7799]

Hi Paul,

Please try this

=((pow((((SUM({$<year=,year={$(=max(year))}

>}[sales]))/100000)

/

((SUM({$< year=,year={$(=max(year-4))}

>}[sales]))/100000)),(1/4))-1)*100)

I thing you have to create master calendar in your data model in proper way...

[paulyeo11]

Hi QV7799

Thank you for your sharing.

I have apply your expression into my table , i found that the result is wrong.

Base on cal is 18% but your display -219%

Paul

[prma7799]

Can you please send your expected output

please