Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
@Rakhesh Perhaps this as expression?
Aggr(If(Rank(Sum([Count of part Number]))<=2, Sum([Count of part Number])), Supplier, Manager)
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