ytd average

[Masi_Sahargahi]

Hi all,

I have a measure (Account balance) which I want to calculate and show daily average for it for any date(sum of daily balance from the beginning of the year till that day/number of days tills that day) and user might not filter any date.

I am supposed to show a strait table which contains day (Dimension) and daily average for each day.

https://community.qlik.com/blogs/qlikviewdesignblog/2015/11/02/the-as-of-table?_ga=2.214958487.12661...

I read a solution in following article and it worked but with low efficiency, so  if someone has another solution with set analysis ,I’d really appreciate.

[sunny_talwar]

If the above solution worked with low efficiency, any other alternative is going to give you worse performance compared to what you get with As Of Table.

[Masi_Sahargahi]

Thanks for your answer,but as daily balance is a common measure,I think it should  be another strait forward solution like using set analysis...