topic last 6 weeks same day avg. in QlikView

last 6 weeks same day avg.

Abhi999 — Mon, 10 Aug 2020 11:44:03 GMT

I am trying with same expression(Only( Aggr( Sum(Total<Weekday> Value) / count(Total<Weekday> DISTINCT Date) , Weekday, Date))) for last six weeks. but unfortunately we are not getting expected result.

cloud you help me for last 6 weeks same day avg.

Example: today beeing monday i want to calculate what will be the avg of last 6 mondays, same for other days.

Trying to show combo chart, in combo chart bars i want to show actulas and in trend line i want to show if it monday last 6 monday's avg, if it tues day last 6 tuesday's avg.

Re: last 6 weeks same day avg.

Kushal_Chawda — Mon, 10 Aug 2020 13:22:41 GMT

Is it duplicated thread?

https://community.qlik.com/t5/Qlik-Sense-App-Development/Rolling-6-weeking-avg/m-p/1734358#M56099

Re: last 6 weeks same day avg.

Abhi999 — Mon, 10 Aug 2020 18:35:14 GMT

Re: last 6 weeks same day avg.

Brett_Bleess — Tue, 25 Aug 2020 15:22:34 GMT

Have a look at the following Design Blog post, it may get you on the right track or help you get things sorted, you may need to search the other posts in this area for other items to help as well, so I will post the main link too, which you can use to further search those posts:

https://community.qlik.com/t5/Qlik-Design-Blog/Average-Which-average/ba-p/1466654

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

There are likely multiple ways to approach this one, so it will likely be helpful if you can attach QVW file for folks to see the data model etc. too.

Regards,
Brett