topic Re: Moving Average Multiple Dimensions is wrong in QlikView

Moving Average Multiple Dimensions is wrong

__johan__ — Sat, 16 Nov 2024 02:25:32 GMT

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

Re: Moving Average Multiple Dimensions is wrong

Brett_Bleess — Tue, 01 Oct 2019 16:27:19 GMT

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

Re: Moving Average Multiple Dimensions is wrong

sunny_talwar — Tue, 01 Oct 2019 17:42:48 GMT

May be this

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