Moving Average Multiple Dimensions is wrong

[__johan__]

Hi, I have two dimensions in a straight table were I'm trying to calculate moving average for 12 months. Everything looks good when selecting just one chain but when deselecting chain calculation doesn't consider multiple chains so entire expression is wrong. Why?

This is the expression I'm using: Sum(Aggr(RangeAvg(Above(TOTAL sum({<Type = {'Registration'},AddOnFlag = {'N'}>}Applied),0,12)), Chain, Month))

[Brett_Bleess]

Not sure if this will help or not, but since nobody else has posted, figure it was better than nothing:

https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130

You can search yourself in the Design Blog area by using the following link if the above is not what you need, you may be able to find something else that fits better:

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

Regards,
Brett

[sunny_talwar]

May be this

Sum(Aggr(RangeAvg(Above(Sum({<Type = {'Registration'}, AddOnFlag = {'N'}>} Applied), 0, 12)), Chain, Month))