topic Re: comparing customers and ranking in QlikView

comparing customers and ranking

Wed, 30 Apr 2014 11:47:07 GMT

Hi,

I was trying to compare customers in specific year and show the best 5 customers in terms of sales.

here is my script:

=if(aggr(rank(Sum({<Year = {'$(=Max(Year))'}>}Sales)),Year,Customer)=5, Customer)

it seems that scripts returns " the 5th" in rank instead of " the 5 best customers". Any idea ?

thanks

its_anandrjs — Wed, 30 Apr 2014 11:49:58 GMT

Try like below script

=if(aggr(rank(Sum({<Year = {'$(=Max(Year))'}>}Sales)),Year,Customer)>5, Customer)

=if(aggr(rank(Sum({<Year = {'$(=Max(Year))'}>}Sales)),Year,Customer)<5, Customer)

=if(aggr(rank(Sum({<Year = {'$(=Max(Year))'}>}Sales)),Year,Customer)<=5, Customer)

MK_QSL — Wed, 30 Apr 2014 11:50:05 GMT

IF(Aggr(Rank(SUM({<Year = {'$(=Max(Year))'}>}Sales),4),Customer)<=5, Customer)

ashfaq_haseeb — Wed, 30 Apr 2014 11:50:08 GMT

Hi try

below code.

=if(aggr(rank(Sum({<Year = {'$(=Max(Year))'}>}Sales)),Year,Customer)<=5, Customer)

Regards

ASHFAQ

anbu1984 — Wed, 30 Apr 2014 11:54:57 GMT

Replace = by <=

=if(aggr(rank(Sum({<Year = {'$(=Max(Year))'}>}Sales)),Year,Customer)<=5, Customer)

Wed, 30 Apr 2014 12:05:54 GMT

Thanks a lot

Is there a way to sort out ? Best customer highest in the list ?

MK_QSL — Wed, 30 Apr 2014 12:08:31 GMT

Create a new thread !