calculate YOY index

[Captain_Jack]

Hello Everyone

I have some experience in power BI , but I am new to Qlik. can I kindly ask if someone could help me out here, I am stucking with this question for many days :(.

I have a table on left with forecast and sales ,  how could I get an index (YOY) on all years( without filter the year), and pick the latest forecast version if there is not forecast_version is selected?

I tried below to calculate the index , but it is not correct.

(sum({<year={$(=max(year))},year_week={">=$(=max(forecast_version))"}>}forecast) +

sum({<year={$(=max(year)},year_week={"<$(=max(forecast_version))"}>}sales))

/

(sum({<year={$(=max(year)-1)},year_week={">=$(=max(forecast_version))"}>}forecast) +
sum({<year={$(=max(year)-1)},year_week={"<$(=max(forecast_version))"}>}sales))*100