Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
maurizio_masini
Contributor II
Contributor II

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

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

NameValue
A100
B

120

C90
D180
---

30

Other200

How I'd like it

NameValue
D180
B120
A100
C90
Other200
---30

Thanks

1 Solution

Accepted Solutions
Nicole-Smith

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

if(Name = 'Other', -1,

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

Capture.JPG

View solution in original post

2 Replies
Nicole-Smith

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

if(Name = 'Other', -1,

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

Capture.JPG

maurizio_masini
Contributor II
Contributor II
Author

Works smoothly !!!

thanks