topic Re: Rolling 3 Month Avg in QlikView

Rolling 3 Month Avg

Hum1 — Sat, 16 Nov 2024 01:30:10 GMT

Is there a way someone can explain to be why my rolling 3 months Avg (3 MMM) is displaying large numbers.

Expression for Rolling 3 Month (3 MMM) :

if(Month='Apr', sum(aggr(rangesum((sum((BookAmt/Act + OL)))),Month)),
if(Month='May' ,sum( aggr( rangesum( above( sum((BookAmt/Act + OL)/2)),0,1 ),Month)) ,
sum( aggr( rangesum( above( sum(((BookAmt/Act + OL)/3)),0,3) ),Month))))

Re: Rolling 3 Month Avg

Arthur_Fong — Thu, 16 Jan 2020 00:41:35 GMT

Try:

if(Month='Apr', sum(aggr(rangesum((sum({<Month={'Apr'}>}(BookAmt/Act + OL)))),Month)),
if(Month='May' ,sum( aggr( rangesum( above( sum({<Month={'May'}>}(BookAmt/Act + OL)/2)),0,1 ),Month)) ,
sum( aggr( rangesum( above( sum(((BookAmt/Act + OL)/3)),0,3) ),Month))))

Re: Rolling 3 Month Avg

Brett_Bleess — Wed, 12 Feb 2020 21:28:42 GMT

Did Arthur's suggestions work? If so, do not forget to return to your post and use the Accept as Solution button on his post to give him credit for the assistance and to let other Members know that worked. If you are still working upon things, please leave an update.

A useful area for how-to type solutions is here, there are over 700 posts in this area from our internal experts, so worth bookmarking for future reference:

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

Regards,
Brett