topic Re: Set analysis (Latest value) in QlikView

Set analysis (Latest value)

Anonymous — Tue, 22 Oct 2013 17:25:47 GMT

ID	# OF PAYMENT	Value
001	1	100
001	2	150
001	3	175
002	1	50
003	1	100
003	2	100

This expression =SUM({$<[# OF PAYMENT]={$(=max([# OF PAYMENT]))}>}Value) returns value= 175 because it has the latest payment which is not the desired result.

I need an expression that returns 175 + 100 + 100 = 375 because the latest payment for ID 001 is 175, ID 002 IS 50 and ID 003 is 100.

Thanks

Re: Set analysis (Latest value)

Gysbert_Wassenaar — Tue, 22 Oct 2013 18:13:22 GMT

Try =sum(aggr(FirstSortedValue(Value,-[# OF PAYMENT]),ID))

btw, the result is 325, not 375

Re: Set analysis (Latest value)

preminqlik — Tue, 22 Oct 2013 18:30:06 GMT

hi,

PFA

hope it helps u

regards

Premhas

Re: Set analysis (Latest value)

Anonymous — Wed, 23 Oct 2013 09:15:57 GMT

Thanks alot guys