Average of last 3 years

[bhavvibudagam]

Hi can any help me to do

in the below attached screen shot

how to calculate the last 3 years average.Which expression we have to write for count of Last 3 years average.

and how to calculate the "36 months rolling Avg".

I have Year,Month for count MAINID Field are their .

Thanks.

[mightyqlikers]

hi,

share some sample data and expected output here.

$@M.    

[MindaugasBacius]

avg({<

     Date={">=$(=addmonths(max(Date), -36)"}

>}Data)

Addmonths works when Data format is YYYY-MM-DD.

[#4]

try with

Avg( Aggr( Sum(MAINID ), Month) )

[bhavvibudagam]

This is the pivot table i was built in qlikview.My requirement is i need to find out the last 3years average i.e

110+106+96/3 .

My dimensions are statusdate year,statusdate month

Expression: =Count({<STATUS={'CL','},>}MAINID)

How to find the 3years average for this table

[bhavvibudagam]

This is the pivot table i was built in qlikview.My requirement is i need to find out the last 3years average i.e

110+106+96/3 .

My dimensions are statusdate year,statusdate month

Expression: =Count({<STATUS={'CL','},>}MAINID)

How to find the 3years average for this table

[sunny_talwar]

So instead of seeing 110 for Year = 2016 and Month = Jan, you would want to see 104? and similarly each cell will be made up of 3 year's average for the same cell?

[bhavvibudagam]

Yes sunny

[bhavvibudagam]

Hi sunny,

I have another requirement i.e calculate the Median Reponse Time.I have attached the sample qvw file.Please find the below.

I have Two fields AR_SEC,S_SEC.need to calculate he median response time for these two fields.

The output like for priority1  -->6.08 minutes.Please help me to calculate the median response time.