topic Rank for table in QlikView

Rank for table

Fri, 27 Apr 2012 20:21:01 GMT

I have a dimension country.

I want to know for each country in a table, which is the top product with sum(sales)

It should look like this:

Country Product

Mexico A

England B

USA C

France A

I tried with:

I tried combining if, rank and aggr but with no luck yet.

Any ideas?

Regards

Federico

Fri, 27 Apr 2012 20:23:39 GMT

This is my last idea, but only shows the ranked 1 product disregarding the country

(In a table with country as dimension)

=Aggr(if(Rank( Sum(Sales))=1, Product),Product)

Fri, 27 Apr 2012 20:46:17 GMT

The solution is:

=Aggr(if(Rank( Sum(Sales))=1, Product),Country,Product)

Didn't know that the order matter, I had already tried =Aggr(if(Rank( Sum(Sales))=1, Product),Product,Country)

Fri, 27 Apr 2012 20:48:45 GMT

Try without the IF condition and with Rank out of Aggr function:

Rank(Aggr(Sum(Sales), Product))

I hope this help you.

Luciano.-

Fri, 27 Apr 2012 22:32:14 GMT

Hi Luciano. Found the answer.

You solution returns numbers when I need text values.