calculate index on all years

[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

[JordyWegman]

Hi,

What is the outcome of one part of the formula? Does that work?

It helps to scale down the calculation and start small. Then extend with parts and see if it still works!

Jordy

Climber