topic Re: Get Top Customer Name based on Sales in QlikView

Get Top Customer Name based on Sales

Thu, 11 Jun 2015 11:32:19 GMT

Hello Community,

I am trying to display the top result from Customer field based on maximum value in Sales field; in this case (refer below table), I want to display Customer "XYZ" in a text box. How can I achieve this?

Also Note: Below Values are dynamic and will change

Customer	Sales
ABC	30
XYZ	100
QWE	25
ASD	20
OPL	20

Thanks,

Re: Get Top Customer Name based on Sales

fvelascog72 — Thu, 11 Jun 2015 11:35:38 GMT

Hi,

Try this in the text Object:

=Concat({<Sales={'$(=Max(Sales))'}>}Customer, ',')

Re: Get Top Customer Name based on Sales

buzzy996 — Thu, 11 Jun 2015 11:36:11 GMT

try tis,

Re: Get Top Customer Name based on Sales

Thu, 11 Jun 2015 11:39:20 GMT

It worked!! Thanks Federico!!

=only({<sales={'$(=Max(sales))'}>}customer) --> returns only 1 value...

but

=concat({<sales={'$(=Max(sales))'}>}customer) --> return all possible value

eg: if i wanted customers doing low or least sales..then I will use concat in my case since it has two values.

=concat({<sales={'$(=Min(sales))'}>}customer) --> returns ASD,OPL

Re: Get Top Customer Name based on Sales

sushil353 — Thu, 11 Jun 2015 11:40:28 GMT

Try:

firstsortedvalue(Customer,-Aggr(Sum(Sales),Customer))

Re: Get Top Customer Name based on Sales

fvelascog72 — Thu, 11 Jun 2015 12:04:14 GMT

Yes, you are right,

First I posted only, but later I edit post with concat option.

Regards

Re: Get Top Customer Name based on Sales

Thu, 11 Jun 2015 12:15:31 GMT

This works as well!!

firstsortedvalue(Customer,-Aggr(Sum(Sales),Customer))