Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
jlampard40
Contributor III
Contributor III

CAGR Calculation

Hi - I have an excel spreadsheet with 5 years worth of activity data.  The yearly dates are displayed as:

FY14/15
FY15/16
FY16/17
FY17/18
FY18/19
FY19/20

I need to calculate the CAGR across these 5 years.  My date field is called [AD_FY].  Can anyone help?    Thankyou.

1 Reply
Brett_Bleess
Former Employee
Former Employee

Best I can offer with what you have provided is to have a look in the Design Blog are to see if you can find something to help there, or search the Community posts to see if someone else has posted something similar in the past.  In these cases, in order to get the help you want, you may want to consider attaching an example QVW file with data model and chart/expressions etc. you want to be working, that way folks can ensure they get you what you need.  Think in terms of whether or not you would have the info needed to try to help someone else if they posted what you are posting, that should hopefully help put things into perspective.  

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.