Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

wanyunyang
Contributor

Get the top rank retailer

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!

1 Solution

Accepted Solutions

Re: Get the top rank retailer

May be try this

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

3 Replies

Re: Get the top rank retailer

May be try this

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

wanyunyang
Contributor

Re: Get the top rank retailer

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

Re: Get the top rank retailer

no idea... can you share a sample?

Community Browser