Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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
Valued Contributor III

Re: How show top ranked salesperson within each client in straight table

hi,

try the attach application

Deepak

3 Replies
deepakk
Valued Contributor III

Re: How show top ranked salesperson within each client in straight table

hi,

try the attach application

Deepak

MVP
MVP

How show top ranked salesperson within each client in straight table

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

Re: How show top ranked salesperson within each client in straight table

Thank  you!