Top Products

[niranjana]

Hi,

I have a requirement where I have to show  Products with top sales in a text box in Qlik. IN case, I have two products with equal highest sales, I have to show BOTH  Products in the text box . How to do that?

Thanks in advance

[tresesco]

Try something like:

=Concat({<Product={"=Rank(Sum(Sales))=1"}>}Product, '|')

[niranjana]

Hi,

I tried the formula its working partially. The Products are coming but being repeated many times like :

Pdt1,Pdt 1,Pdt1, Pdt2,Pdt2,Pdt2 ,.......and so on

[tresesco · Accepted solution]

Put a distinct, like  =Concat(Distinct {<Product={"=Rank(Sum(Sales))=1"}>}Product, '|')

[niranjana · Accepted solution]

Thanks a lot!! Its working!