topic ytd average in QlikView

ytd average

Masi_Sahargahi — Wed, 25 Nov 2020 16:16:04 GMT

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.1266132063.1513589522-1487155068.1508055132

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.

Re: ytd average

sunny_talwar — Tue, 23 Jan 2018 13:01:03 GMT

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.

Re: ytd average

Masi_Sahargahi — Wed, 24 Jan 2018 06:25:22 GMT

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...