show the Top 3 bar chat sales man name in text box

[stephenedberkg]

I have the bar chat like this i want to show the top bar chat name is textbox

in bar char i am using this formula

=num(sum({<   Year = {$(=Max(Year))},MarketID  = {'SAUDI ARABIA'},MonthID  = {$(=Max(MonthID))}>}Conversionsales),0.00)

Thanks in Advance

[jonathandienst]

Please provide a sample qvw file:

Preparing examples for Upload - Reduction and Data Scrambling

A least provide full information on the data fields and the table structure of your model - at least those relevant to your question.

[stephenedberkg]

dear jontydkpi,\

i dont have the QVW file.i saw the dashboard like this.i have only png image

[awhitfield]

HI Stehen,

check out following post:

https://community.qlik.com/blogs/qlikviewdesignblog/2013/02/08/displaying-the-top-salesperson-in-a-t...

HTH - Andy

[stephenedberkg]

i tried but i cant get the solution

[awhitfield]

Hi Stehen,

very simple example attached, using the second method

Andy

[stephenedberkg · Accepted solution]

i got the answer.

my formula in text box below

=only(if(aggr(Rank(sum(Conversionsales)),[sales Man])=1,[sales Man]))