Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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"
Could you please provide the sample data and explain more ??
Perhaps rank(sum(sales)) or maybe rank(sum(total <Company> sales))
This is how it would work in Excel. I want to recreate the "Rank" column in Qlikview
That just puts a '1' in the column for everything
Ok, so using something as simple as =Rank(Sales) works, however if I then add another column, say Sales Person it then falls over
It would help if you can post a small qlikview document that demonstrates the problem.
AGGR(RANK(SALES,1,1),Company,SalesPerson)