display the top article in a text box

[pirotfab]

Hello,

I want to display in the text box t: the top seller (sum sales), the top article ...

Is it possible?

thank you in advance

Fabien

[sunny_talwar · Accepted solution]

You can use FirstSortedValue here:

=FirstSortedValue(DISTINCT Seller, -Aggr(Sum(Sales), Seller))

=FirstSortedValue(DISTINCT Article, -Aggr(Sum(Sales), Article))

[maxgro]

2 useful link

Qlik Design Blog : Displaying the Top Salespers... | Qlik Community

Show Top Performers | Qlik Community

[swuehl]

=Only({<Seller = {"=Rank(Sum(Sales),4)=1"}>} Seller)

=Only({<Article= {"=Rank(Sum(Sales),4)=1"}>} Article)

You can play with the arguments of Rank() and use Concat() instead of Only() to display nonunique top Article / Seller with a same Sales amount, if you prefer this.

[pirotfab]

thank you is exactly that