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.
