Maximum Value Required

[#1]

Dear All,

I want the maximum sales by a dealer for one year (monthly figures available). Using 'max' function in excel we can get it but in Qlikview how do I write the expression.

Rahul

[#2]

It could be something like this:

=max(aggr(sum({<Year={$(=max(Year))}>} Sales), Dealer))

or

=max(aggr(sum(Sales), Dealer, Year))

or

=max(aggr(sum({<Year={2010}>} Sales), Dealer))

or something else. Your condition has many interpretations