topic Re: How can I calculate the MM4 ? in QlikView

How can I calculate the MM4 ?

suzel404 — Sat, 12 Dec 2015 04:58:50 GMT

Hi all,

How can I calculate the Moving Average of type 4 dynamically:

MM4 = 1/4[(1/2 Q1-2011) + Q2-2011 + Q3-2011 + Q4-2011 + 1/2(Q1-2012)]

Thanks for your help.

maxgro — Sat, 12 Dec 2015 07:37:06 GMT

maybe

0.25*

rangesum(

0.5*Above(total Sum(SALESINCOME), 2),

Above(total Sum(SALESINCOME), 1),

Sum(SALESINCOME),

Below(total Sum(SALESINCOME), 1),

0.5*Below(total Sum(SALESINCOME), 2)

)

petter — Sat, 12 Dec 2015 08:24:53 GMT

Above(TOTAL Sum(SALESINCOME),2)/2+RangeSum(Above(TOTAL Sum(SALESINCOME),0,2))+Below(TOTAL Sum(SALESINCOME))+Below(TOTAL Sum(SALESINCOME),2)/2

suzel404 — Sat, 12 Dec 2015 16:41:37 GMT

Many thanks for your help guys!!