topic Re: Ranking in QlikView

Ranking

kevbrown — Fri, 16 Dec 2016 11:32:23 GMT

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"

Re: Ranking

avinashelite — Fri, 16 Dec 2016 11:47:20 GMT

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

Re: Ranking

Gysbert_Wassenaar — Fri, 16 Dec 2016 11:48:11 GMT

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

Re: Ranking

kevbrown — Fri, 16 Dec 2016 11:57:03 GMT

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

Re: Ranking

kevbrown — Fri, 27 Jan 2017 10:15:06 GMT

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

Re: Ranking

kevbrown — Fri, 27 Jan 2017 10:28:57 GMT

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

Re: Ranking

Gysbert_Wassenaar — Sun, 29 Jan 2017 07:01:30 GMT

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

Re: Ranking

vinieme12 — Sun, 29 Jan 2017 09:46:24 GMT

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