Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

kevbrown
Contributor II

Ranking

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"

7 Replies

Re: Ranking

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

MVP & Luminary
MVP & Luminary

Re: Ranking

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


talk is cheap, supply exceeds demand
kevbrown
Contributor II

Re: Ranking

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

kevbrown
Contributor II

Re: Ranking

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

kevbrown
Contributor II

Re: Ranking

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

MVP & Luminary
MVP & Luminary

Re: Ranking

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


talk is cheap, supply exceeds demand
vinieme12
Esteemed Contributor II

Re: Ranking

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