Creating YTD average starting from 01/01/2016

[#1]

I have data of scrap as a percentage (x kilos of scrap/ z kilos of product) for each week of 2016. I have created a bar chart to display this data. I would like to add a line for YTD average. So for week 1 it will equal week 1, for week 2 it will be (week 1 + week 2)/2,

then (week 1+week2+week3)/3, and so on. How can I do this?

[#2]

Sweet as. Thanks for your help.

Any suggestions for learning Qlikview?

All the best

Terry

[Gysbert_Wassenaar]

See How to become a QlikView Developer?‌

There are more good books that you could read to learn more: Books and literature