topic Maximum value per field in QlikView

Maximum value per field

marcel_olmo — Wed, 23 Oct 2013 15:13:34 GMT

Hi guys,

I have a table like this :

And I'd like to get in a table, the maximum possible amount by Transaction Id per Company, that will be --> 10 + 5 + 2 = 17.

This is what I'm trying :

num(sum( {$ < [Transaction Id] = {$(=max([Transaction Id]))} >} Amount),'#.##0,00 €')

aggr( num(sum( {$ < [Transaction Id] = {$(=max([Transaction Id]))} >} Amount ),'#.##0,00 €') , Company )

But I only got the maximum value of the maximum Transaction Id.

I've attached the example.

Do yo know how to get my desired result?

Many thanks in advance!

Wed, 23 Oct 2013 15:28:21 GMT

Hi Marcel

Here it is

best regards

Chris

jonathandienst — Wed, 23 Oct 2013 15:31:13 GMT

This should do what you want if I have understood you correctly

Sum(Aggr(FirstSortedValue(Amount, -[Transaction Id]), Company))

HTH

Jonathan

marcel_olmo — Wed, 23 Oct 2013 15:36:48 GMT

Thanks guys!

It worked with firstSortedValue. Thank you guys!

yduval75 — Wed, 23 Oct 2013 15:39:45 GMT

=FirstSortedValue(Amount, -[Transaction Id]) is much better !

Thanks Jonathan