Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How show top ranked salesperson within each client in straight table

Hello,

I have a dataset that looks like this

Clients   Salespeople   Sales($)

I'd like to have a straight table chart that shows for all Clients:

Clients        Top Salesperson's Name for that Client         Top Salesperson's Sales with that Client

fyi,

I've been working with the expression:

=sum({$< Salesperson={"=rank(sum(Sales),4,1)=1"}>}  Sales)

but this only gives the Name and Sales for the top Salesperson across all clients, not per client.

Any help much appreciated.

Thank you!

1 Solution

Accepted Solutions
deepakk
Partner - Specialist III
Partner - Specialist III

hi,

try the attach application

Deepak

View solution in original post

3 Replies
deepakk
Partner - Specialist III
Partner - Specialist III

hi,

try the attach application

Deepak

swuehl
MVP
MVP

This should be quite straight forward in QV11, using the dimension limits in straight table properties.

Create a chart with the two dimensions Clients and Salespeople and as expression sum(Sales).

Then enable 'Restrict which values are displayed..' in dimension limits tab for the second dimension Salespeople and select Largest 1 value.

Hope this helps,

Stefan

Not applicable
Author

Thank  you!