topic Re: Simple average expression in QlikView

Simple average expression

Tue, 02 Sep 2014 13:52:55 GMT

Dear all,

I need an expression that returns the following ranking :

I have successfully calculated the following simple average:

Avg( {$<Category={1}>} Amount )

and I have another dimension "Country" in a Multi box and whenever I make a choise, the above average is obviously calculated for the selected country.

What I need is an expression that calculates the max average from every country for this category=1, despite the country changes in the multibox. In other words, i want to return a static number that is the value of the max average for the country that ranks first of all averages. Can anyone help me on this please ??

Thank you!

Re: Simple average expression

MK_QSL — Tue, 02 Sep 2014 14:00:36 GMT

=Aggr(Rank(Avg({<Category={1}, Country= >}Amount)),Country)

Re: Simple average expression

Tue, 02 Sep 2014 14:06:33 GMT

Mr Manish I need the value of the maximum average that ranks first of all countries for this category=1, not the rank of the selected country as you had correctly answered me on another post @Simple Rank expression.

Thank you very much for your valuable time

Re: Simple average expression

MK_QSL — Tue, 02 Sep 2014 14:16:42 GMT

Max({<Country = >}TOTAL Aggr(Avg({<Category = {1}, Country = >}Amount),Country))

Re: Simple average expression

Tue, 02 Sep 2014 14:42:53 GMT

That was exaclty I needed. Thank you again.

Your sincerely,