how to bring Top top 50 cusromer

[#1]

Hello,

i am working in qlikviw v-11           .

          dim                                                                       Exp                            

Segment        customer                                   Qtyin ton               Sales value

c1

c2

What i want is  top 50 customer for c1 and c2 seperately. by "sales value" and by "Qty in tons".

I have written exp for sorting in sort tab in this way

"

if(Filter = 'By Tons',  Aggr(if(Rank(Sum(SalesQty),100,1) <=100 , Sum(SalesQty)), SEGMENT, Customers),

if(Filter = 'By Value', Aggr(if(Rank(Sum(SalesValue),100,1) <=100  , Sum(SalesValue)), SEGMENT,Customers)))

"

but it shows incorrect sorting for last some records.I stuck up here.

so pls  Help.

[#2]

Please help

it's urgent

Thank u.

[swuehl]

You are using a pivot table, right?

If so, it will be probably impossible to do what you want. Search the forum for this issue (pivot, sort order, sort by expression etc.), here is one reference:

http://community.qlik.com/thread/11434