Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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