topic Re: get 2 lowest Customer name in QlikView

get 2 lowest Customer name

muthukumar77 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I need to get 2 lowest sales Customer name in text box.

I tried to do a expression but its not working.

=only(if(Aggr(rank(Sum(-NetSales)),Customer_CompanyName)=1, Customer_CompanyName))

Can anyone pls tell what is problem?

sunny_talwar — Wed, 15 Mar 2017 08:22:27 GMT

May be try with FirstSortedValue()

Customer with lowest Sales

FirstSortedValue(Customer_CompanyName, Aggr(Sum(NetSales), Customer_CompanyName))

Customer with 2nd lowest Sales

FirstSortedValue(Customer_CompanyName, Aggr(Sum(NetSales), Customer_CompanyName), 2)

devarasu07 — Wed, 15 Mar 2017 08:25:28 GMT

Hi,

Try like below,

=Concat(DISTINCT Aggr(If(Rank(-Sum(Measure)) <=2, Product), Product), ', ')

sunny_talwar — Wed, 15 Mar 2017 09:44:57 GMT

Can also be done using set analysis

=Concat(DISTINCT {<Product = {"=Rank(-Sum(Measure)) < 3"}>}Product, ', ')