calculate YOY index

Captain_Jack — Sun, 09 May 2021 09:18:23 GMT

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

topic calculate YOY index in QlikView

calculate YOY index