topic Re: Top Products in QlikView

Top Products

niranjana — Mon, 09 Aug 2021 07:11:12 GMT

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

Re: Top Products

tresB — Mon, 09 Aug 2021 07:17:16 GMT

Try something like:

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

Re: Top Products

niranjana — Mon, 09 Aug 2021 07:29:34 GMT

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

Re: Top Products

tresB — Mon, 09 Aug 2021 07:31:28 GMT

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

Re: Top Products

niranjana — Mon, 09 Aug 2021 07:46:15 GMT

Thanks a lot!! Its working!