topic find max value on using when using range sum function. in QlikView

find max value on using when using range sum function.

Sat, 02 Apr 2016 07:24:42 GMT

I am using function rangesum in straight table and output is accumulate value,now i want to apply max function on this and find max value according to dimension.

in above screen shot field AccumulateAmount is created from formula "Rangesum(Amount,above(AccumulateAmount)))".

now i want to find out only max value of this field basis on Name .

need output as given below in same qlikview.

ex.

Application also Attached.

Please Suggest what can i do to find max value.

Re: find max value on using when using range sum function.

swuehl — Sat, 02 Apr 2016 09:53:00 GMT

Have you tried dimension Name and as expression

=Sum(Amount)

Should have opened your QVW, try

=Sum(Aggr(FirstSortedValue(Balance,-Date),Name,Account))

Name	Sum(Aggr(FirstSortedValue(Balance,-Date),Name,Account))
	72395
Mohit	10000
Ramesh	47829
Rohit	14566

Re: find max value on using when using range sum function.

Sat, 02 Apr 2016 12:16:57 GMT

Thanks swuehl now it is woking.