AVG value from Max date

jose_vargas — Tue, 07 Feb 2017 23:15:15 GMT

Hello community.

I have the next information in QVD

NumProc | Date | TimeResp | User

-----------------------------------------------------------

1111 15/12/2016 15.00 JVARGAS

1111 17/12/2016 12.25 JVARGAS

1111 13/12/2016 11.50 JRIOS

2222 01/01/2016 10.20 JRIOS

2222 30/12/2016 14.52 JVARGAS

2222 31/12/2016 17.54 JVARGAS

I need the average of "TimeResp" but i just need take the max date for each "NumProc", and this AVG is for User.

So, my result have to be like this:

User | AVG(TimeResp)

----------------------------------------------

JVARGAS 14.90

I have 2 NumProces (1111 and 2222), for 1111 the max date is "17/12/2016" and for 2222 the max date is "31/12/2016", so i use the TimeResp 12.25 and 17.54 for average.

I try whit set analysi but its not work:

AVG({$Date={"$(=max(Date))"}>}TimeResp)

Pelase help what should i use.

Re: AVG value from Max date

sunny_talwar — Tue, 07 Feb 2017 23:18:31 GMT

May be this:

Avg(Aggr(FirstSortedValue(TimeResp, -Date), User, NumProc))

Re: AVG value from Max date

sunny_talwar — Wed, 08 Feb 2017 02:10:44 GMT

Here is a sample attached

Re: AVG value from Max date

jose_vargas — Wed, 08 Feb 2017 15:36:07 GMT

Thanks a lot.. Its Works (Y)

topic Re: AVG value from Max date in QlikView

AVG value from Max date

Re: AVG value from Max date

Re: AVG value from Max date

Re: AVG value from Max date