Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
Masi_Sahargahi
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.

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.

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.

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