topic Re: Top 5 Customer in QlikView

Top 5 Customer

tripatirao — Wed, 07 Oct 2015 10:47:30 GMT

Hi all

I want to show top 5 customer in my textbox.

this is my expression.

=concat(DISTINCT if(aggr(rank(sum({<DELTYPE={SALES}>}AMT_TRANS*$(=Curr_Factor))),CUST_NAME)<=5,CUST_NAME)& CHR(13))

the above expression gives me top 5 customer in a text box but not in proper ascending order.

for ex-

2nd top selling customer coming first

5th top selling customer coming second

but

I want in ascending order.

Thanks in advance.

sujeetsingh — Wed, 07 Oct 2015 10:50:11 GMT

Follow this

Wed, 07 Oct 2015 10:50:14 GMT

Hi Tripati,

Go through the below link it might help u

Wed, 07 Oct 2015 10:52:51 GMT

Hi Tripati,

Digvijay_Singh — Wed, 07 Oct 2015 10:55:54 GMT

There is a sort weight option in Concat, try if you can identify one of you weight field to be used to sort your values.

Wed, 07 Oct 2015 10:58:43 GMT

Hi,

Try with this link

Wed, 07 Oct 2015 10:59:29 GMT

tripatirao — Wed, 07 Oct 2015 12:10:38 GMT

i am not able to get sort weight in concat function...

any solution

thanks