topic Maximum Salary Employee type problem in pivot table in QlikView

Maximum Salary Employee type problem in pivot table

sumitratnani — Wed, 06 Sep 2017 13:42:15 GMT

Hi,

Could anybody help me with following scenario.

Fields:

Client

Division

Account Executive

Income_Brought_By_Account Exec

Client may belong to multiple Divisions.

Each Client can have multiple Account Executives which bring income for that client.

I want a table as below..Where Account Exec Column gives Primary Executive for that Client in that Division(Who brings Max Income for that Client in that Division)

I tried multiple ways, couldn't get the result.

PLease help.

Re: Maximum Salary Employee type problem in pivot table

Anonymous — Wed, 06 Sep 2017 13:44:06 GMT

Try multibox or crosstab

Re: Maximum Salary Employee type problem in pivot table

sumitratnani — Wed, 06 Sep 2017 14:13:18 GMT

(Data Stroke for Confidentiality)

This is the actual scenario. Clients are C1 C2 C3 C4.

There are two expressions :Rank and Account Exec(Gives Primary Account Execs)

Let me know If I have to clearify further.