Rank function

txepulin — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

As much as I searched, I can't find the answer.

I've a table with a single dimension, StoreCodeDesc, and I want to know the weight of the top 100 of the best selling products on the total sales of each store.

On the one hand I want to know the weight that the Top 100 global has, I use the formula:

Sum ({<ArticleCode = {'= rank (Total Sum (NetAmount)) <= 100'}>} NetAmount) / sum (NetAmount)

For another hand I want to know the weight of the Top 100 of each store with the formula without Total:

Sum ({<ArticleCode = {'= rank (Sum (NetAmount)) <= 100'}>} NetAmount) / sum (NetAmount)

Both formulas give me the same result, the weight of the top 100 global sales of each store, but I don't get the weight of the top 100 of each store.

Any ideas?

Regards

Re: Rank function

sunny_talwar — Fri, 09 Mar 2018 17:13:07 GMT

For each store, you can try this

Sum(Aggr(If(Rank(Sum(NetAmount)) <= 100, Sum(NetAmount)), Store, ArticleCode))

Re: Rank function

txepulin — Mon, 12 Mar 2018 11:31:21 GMT

Thanks, it works perfectly.

topic Re: Rank function in QlikView

Rank function

Re: Rank function

Re: Rank function