Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
bhavvibudagam
Creator II
Creator II

Average of last 3 years

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.

8 Replies
mightyqlikers
Creator III
Creator III

hi,

share some sample data and expected output here.

$@M.    

MindaugasBacius
Partner
Partner

avg({<

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

>}Data)

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

Not applicable

try with

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

bhavvibudagam
Creator II
Creator II
Author

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
Creator II
Creator II
Author

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
Creator II
Creator II
Author

Yes sunny

bhavvibudagam
Creator II
Creator II
Author

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.