Ranking

[kevbrown]

Hi,

I'm looking to create a new expression that will give me a ranking column based on the sum of one column for each company in another column, so in effect SumProduct in excel.

To break it down further

New "Rank" Column

For each change in "Company" (e.g 1-10 for BT, 1-10 for O2, 1-10 for Sky)

based on the total of each company "sales"

[avinashelite]

Could you please provide the sample data and explain more ??

[Gysbert_Wassenaar]

Perhaps rank(sum(sales)) or maybe rank(sum(total <Company> sales))

[kevbrown]

This is how it would work in Excel. I want to recreate the "Rank" column in Qlikview

[kevbrown]

That just puts a '1' in the column for everything

[kevbrown]

Ok, so using something as simple as =Rank(Sales) works, however if I then add another column, say Sales Person it then falls over

[Gysbert_Wassenaar]

It would help if you can post a small qlikview document that demonstrates the problem.

[vinieme12]

AGGR(RANK(SALES,1,1),Company,SalesPerson)