topic Re: Rank of top 5 products in QlikView

Rank of top 5 products

Sun, 19 Jan 2014 19:40:12 GMT

Hi can any body pls tell me how to find the rank top 5 sales products having different sales amount.

if sum(sales) in data is same for two products then these are grouped tp gether as one.remaing next sum(sales) we have to count.

regards

Mahesh T

Re: Rank of top 5 products

whiteline — Sun, 19 Jan 2014 19:45:46 GMT

Hi.

Depending on your requirements there are different solutions.

If you want just a table with top 5 products and their sales use dimension limits.

There is also rank() function. So you can use it in expressions or calculated dimensions for more complex cases.

Re: Rank of top 5 products

Sun, 19 Jan 2014 20:12:03 GMT

if two Products sales are same the accordig to requirment it should be groped suppose both having 3rd ranl then thes values as 3rd rank 4th one another one has to select next product value having next highest

Re: Rank of top 5 products

maxgro — Sun, 19 Jan 2014 20:23:48 GMT

different ways to find top performers: community.qlik.com/docs/DOC-5187

interesting discussion on the rank() function Simple Rank() question

Re: Rank of top 5 products

whiteline — Sun, 19 Jan 2014 20:43:32 GMT

As I have already said you can use rank() function.

=aggr(rank(Sum(amount)), Products)

It gives one row for two products if sales are same.

Re: Rank of top 5 products

Sun, 19 Jan 2014 21:24:23 GMT

Hi,

In a table:

Create a calculated dimension:

=Aggr(If(Rank(Sum([Sales]))<=5, Product, 'Others'), Product)

Your expression will just be Sum(Sales)

In a list Box, create an expression:

= Aggr(If(Rank(Sum(Sales)) <= 5, Product), Product)

And you need to sort this express by Sum(Sales) if you to order the products (the above expression only selects, it does not sort)

Fabrice

Re: Rank of top 5 products

iktrayanov — Sun, 19 Jan 2014 21:37:42 GMT

Take a look at this.