Qlik Sense: Unable to sort number and text

[wuming79]

Hi,

I have table as below.

Number of events	Severity
2	High
4	High
6	low
8	medium
10	suspicious

I tried to sort the number of events in Qlik Sense by disabling custom sorting and uncheck any types of sorting under severity and then select custom sort for "number of events" and sort numerically. The table did not sort. I did another KPI chart to sum the number of events and they do add up, confirming the values are numbers.

Another issue is sorting by text. I tried to use sort by Expression MATCH(Severity,'High','medium','low','suspicious') but it also did not sort.

Please help.

[wuming79 · Accepted solution]

It seems like the sort order on the right panel plays a part in sorting.

My problem is fixed.

[McDonald-1022]

Use the Dual function. Dual(Text,Number)  or in your example Dual([Severity], [Number of events])