Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
New Contributor III

ytd average

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.


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.

2 Replies

Re: ytd average

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.

New Contributor III

Re: ytd average

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