Top 2managers form the top Supplier

[Rakhesh]

Hi Team,

I need a solution in qlik view

I have the data like location ,supplier ,manager and there count.

I want the data in frontend table like who is the top supplier and who is the top 2 managers

I have attached the file and the screen shot for reference.

[Anil_Babu_Samineni]

@Rakhesh Perhaps this as expression?

Aggr(If(Rank(Sum([Count of part Number]))<=2, Sum([Count of part Number])), Supplier, Manager)

[Rakhesh]

Hi Anil,

Thanks for your support 

I have one more query ,In the above scenario in each location who is the only one top supplier from their top 2 managers count I want .

Please help me.

Thanks,

Rakhesh