AVG of the last 12 months

[reporting_neu]

Hello,

I always need the AVG for the last 12 months.

It must not be taken into account which year is currently selected. How do I do that?

Avg({<Art = {'R'}> }date(IncomingPayments,'DD.MM.YYYY')-(date(DateOfInvoice,'DD.MM.YYYY')+2))

[Joseph_Musekura]

Hi,

This link shows a calculation of the sum over 12 months in Qlikview.
It can inspire you how to do it in Qlik sense and then calculate the AVG as well

https://community.qlik.com/t5/QlikView-App-Dev/Sum-the-last-twelve-months/td-p/437490
Regards

[reporting_neu · Accepted solution]

Many thanks for your response. I just found a solution.

Avg({IncommingPayments = {">=$(=AddMonths(today(),-12))"}, <Art = {'R'}> }date(IncomingPayments,'DD.MM.YYYY')-(date(DateOfInvoice,'DD.MM.YYYY')+2))

{">=$(=AddMonths(today(),-1))"}

[Joseph_Musekura]

Thanks as well!
/joseph