Calculating YoY

[Faiz]

Hi All,

Date field contains 2013, 2014, 2015 and 2016 data. I have used below formula to calculate YoY growth.

100*(Sum({<[Date.autoCalendar.Year]={"2016"}> }SALES) - Sum({<[Date.autoCalendar.Year]={"2015"}> }SALES))/(Sum({<[Date.autoCalendar.Year]={"2015"}> }SALES))

Instead of using hard coded value of 2015 and 2016, How can I parameterized this date field?

Regards

[qlikeers · Accepted solution]

If I understood correctly:

=(sum({<[Date.autoCalendar.Year]={"$(=max([Date.autoCalendar.Year]))"}> }SALES) - Sum({<[Date.autoCalendar.Year]={"$(=max([Date.autoCalendar.Year],2))"}> }SALES))/ FABS(Sum({<[Date.autoCalendar.Year]={"$(=max([Date.autoCalendar.Year],2))"}> }SALES))

I added Fabs as a form of mathematical security. 🙂