Top Customer sorting

[manojkulkarni]

Hi everybody,

I need help in getting top customers from below table, where I would like to see Others in the bottom. Because Others consists of many small customers. Please any body provide me the better solution.

Name	Sales
Others	2600
Cust1	2500
Cust2	1200
Cust3	1000
Cust4	900
Cust5	700

[manojkulkarni]

Thanks for your replies & solution. But this will not work for my problem.

As mentioned earlier, my data is like below

Name	Sales
Others	2600
Cust1	2500
Cust2	1200
Cust3	1000
Cust4	900
Cust5	700

"Others" is one of the customer name, having clubbed small customers @ data load itself. In chart I want to display actual customers first & later at the bottom merged one's. By default, Others is coming on top because of the highest sales value. But some how i want that to be at bottom. Is there way to sort all customers on there value descending except "Others"

[MK_QSL]

Like this?

[MK_QSL]

CHECK THIS ALSO...

[#5]

Please refer this post : Qlikview Bitz and Pieces: Custom Sort in Qlikview

[maxgro]

I think in sort tab

sort by expression

descending

pick(wildmatch(Name, 'Others', '*'), 'last', sum(Sales))

logic is: sort descending

if Name not  'Others' by sum(Sales)

if name = 'Others' put at the end ('last' or some other string)