topic Monthly Average With Detail Data in QlikView

Monthly Average With Detail Data

danielreber — Wed, 25 Nov 2020 16:16:04 GMT

I have data at the day level but I would like to create an expression that calculates the monthly average for the last six months. I am currently using

=num(avg({< _M={13,12,11,10,9,8} >}total TransactionAMT*-1),'$#,##0')

with "_M" being the month number field and 8-13 being the last six months. However, the calculation is averaging the data at the day level. How do I calculate a monthly average for the last six months?

Thanks

Dan

Re: Monthly Average With Detail Data

danielreber — Thu, 07 Mar 2019 20:58:44 GMT

I believe I figured it out using

=num(avg({< _M={13,12,11,10,9,8} >} aggr(sum(TransactionAMT*-1),_M)),'$#,##0')

Is this correct?

Re: Monthly Average With Detail Data

sunny_talwar — Fri, 08 Mar 2019 02:00:17 GMT

@danielreber wrote:
I believe I figured it out using
=num(avg({< _M={13,12,11,10,9,8} >} aggr(sum(TransactionAMT*-1),_M)),'$#,##0')
Is this correct?

Looks correct to me