Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Put a distinct, like =Concat(Distinct {<Product={"=Rank(Sum(Sales))=1"}>}Product, '|')
Thanks a lot!! Its working!
Try something like:
=Concat({<Product={"=Rank(Sum(Sales))=1"}>}Product, '|')
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
Put a distinct, like =Concat(Distinct {<Product={"=Rank(Sum(Sales))=1"}>}Product, '|')
Thanks a lot!! Its working!