Get the top rank retailer

[wanyunyang]

Hi guys,

I want to get the top rank retailer in QLIK SENSE. My function is: IF(AGGR(RANK(SUM(orderTotal)),Retailer)=1,Retailer). But it shows nothing. How should I modify my function?

Thanks for help!

[sunny_talwar · Accepted solution]

May be try this

Concat(DISTINCT {<Retailer = {"=Rank(Sum(orderTotal)) = 1"}>} Retailer)

[wanyunyang]

I did Only(IF(AGGR(RANK(SUM(orderTotal)),Retailer)=1,Retailer)) and it works... Why does this function need ONLY?

[sunny_talwar]

no idea... can you share a sample?