Maximum Value Required

Thu, 01 Jul 2010 13:28:18 GMT

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

Maximum Value Required

Thu, 01 Jul 2010 13:44:31 GMT

It could be something like this:

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

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

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

or something else. Your condition has many interpretations

topic Maximum Value Required in QlikView

Maximum Value Required

Maximum Value Required