topic 5 largest Customers for agents in QlikView

5 largest Customers for agents

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

Hello

Enclosed is a qlik document

it show in pivot table

agent , customers and total sales

i was to show only the 5 biggest customers , form each agent .

the manager what to see who are the biggest customer for each agent

thanks for your help

gidon

effinty2112 — Sun, 10 Sep 2017 14:43:42 GMT

Hi Gidon,

Try this pivot table:

Customer is the calculated dimension:

=Aggr(If(Rank(Sum(SALES))<=5,CUSTNAME),AGENTCODE,CUSTNAME)

Regards

Andrew

gidon500 — Sun, 10 Sep 2017 17:33:37 GMT

Hi Andrew

thanks for your fast response

I got one more line without CUSTNAM

How can I fix it

thanks

gidon

effinty2112 — Sun, 10 Sep 2017 18:11:20 GMT

Hi Gidon,

In the pivot table's dimension tab click the checkbox for Suppress When Value Is Null.

Regards

Andrew