Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Can you throw in some sample data which shows how your data is structured?
Hi Sunny
I have attach my QV doc when i reply QlikView 7799 post.
Paul
Oh right, did not look at that. Will check it out now
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
Hi Paul,
Try to convert my fields with your existing fields.
Here I am not able to open your QVW.
Thanks
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
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...
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
Can you please send your expected output
please