Qliksense - Sort data in table: put 'others' at bottom, keep numeric value sorting

[maurizio_masini]

I have a problem in sorting data in a table according to my 'taste'.

The table has names and values and two of the names are 'other' and 'blank'. They both have a value.

So, if I sort Alpha by name, they can be placed at the bottom using Wildmatch, but then the value order is not respected. If I sort via value, it's obvious they won't be at the bottom.

is there a way to achieve this?

How it is

Name	Value
A	100
B	120
C	90
D	180
---	30
Other	200

How I'd like it

Name	Value
D	180
B	120
A	100
C	90
Other	200
---	30

Thanks

[Nicole-Smith · Accepted solution]

You can add Sort by Expression to Name, and get those results using the following expression:

if(Name = 'Other', -1,

if(Name = '---', -2, Value))

[maurizio_masini]

Works smoothly !!!

thanks