topic Re: Sum of Maximum Values in QlikView

Sum of Maximum Values

Wed, 20 Aug 2014 02:13:58 GMT

Hello,

I am trying to sum the maximum value of a field, and not sure which function to use.

I can get the maximum value without any problems using Max or Maxstring, but when I go to sum those values I run into trouble.

In the example below I want to sum the yellow shaded odomoter readings to get a result of 171,747:

Any help appreciated.

Thanks

Wed, 20 Aug 2014 02:24:06 GMT

Wayne

If I understand correctly, you could use something like the following expression:

=SUM(AGGR(MAX(ODOMOTER),REGO))

-Clark

nagaiank — Wed, 20 Aug 2014 02:27:08 GMT

You may use

=Sum(Aggr(FirstSortedValue(ODOMOTER,-DATE),REGO))

Thu, 21 Aug 2014 04:02:59 GMT

Thanks Clark,

That's what I was looking for.

Wayne