Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
May be try this
Concat(DISTINCT {<Retailer = {"=Rank(Sum(orderTotal)) = 1"}>} Retailer)
May be try this
Concat(DISTINCT {<Retailer = {"=Rank(Sum(orderTotal)) = 1"}>} Retailer)
I did Only(IF(AGGR(RANK(SUM(orderTotal)),Retailer)=1,Retailer)) and it works... Why does this function need ONLY?
no idea... can you share a sample?