Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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 |
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 |
Thanks swuehl now it is woking.