topic Re: Concatenate top 5 Store in QlikView

Concatenate top 5 Store

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

Hi All,

Using below expression able to get top selling store. but how to top 5 store ? any suggestion. Thanks

=Concat(DISTINCT Aggr(If(Sum(SoldQty) = Max(TOTAL <ArticleNo> Aggr(Sum(SoldQty), ArticleNo, StoreName)), StoreName), ArticleNo, StoreName), ', ')

Current Output,

Expected output like below,

Note:

tried like below and it's not working.

=if(aggr(rank(sum(SoldQty)),ArticleNo)<=5,

Concat(DISTINCT Aggr(If(Sum(SoldQty) = Max(TOTAL <ArticleNo> Aggr(Sum(SoldQty), ArticleNo, StoreName)), StoreName), ArticleNo, StoreName), ', ') )

Thanks,

Deva

sunny_talwar — Fri, 17 Feb 2017 11:56:52 GMT

How about this:

=Concat(DISTINCT Aggr(If(Rank(Sum(SoldQty)) < 6, StoreName), ArticleNo, StoreName), ', ')

=Concat(DISTINCT Aggr(If(Sum(SoldQty) <= Max(TOTAL <ArticleNo> Aggr(Sum(SoldQty), ArticleNo, StoreName), 5), StoreName), ArticleNo, StoreName), ', ')

devarasu07 — Fri, 17 Feb 2017 12:48:52 GMT

Hi Sunny,

Perfect working fine

Regards, Deva