Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
niranjana
Creator
Creator

Top Products

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

2 Solutions

Accepted Solutions
tresesco
MVP
MVP

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

View solution in original post

niranjana
Creator
Creator
Author

Thanks a lot!! Its working!

View solution in original post

4 Replies
tresesco
MVP
MVP

Try something like:

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

niranjana
Creator
Creator
Author

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
MVP
MVP

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

niranjana
Creator
Creator
Author

Thanks a lot!! Its working!