Top 5 Customer

[tripatirao]

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]

Follow this

QlikView 11 Dimension Limit Functionality

[#3]

Hi Tripati,

Go through the below link it might help u

Not able to sort correctly a top 10 in a bar chart

[#4]

Hi Tripati,

Selecting Ascending 5 Values in expression

[Digvijay_Singh]

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.

[#6]

Hi,

Try with this link

Aggr and rank not sorting in Text box

[#7]

QlikView Technical Brief - AGGR.docx

[tripatirao]

Hi

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

any solution

thanks