topic Qlik Sense: Unable to sort number and text in QlikView

Qlik Sense: Unable to sort number and text

wuming79 — Wed, 24 Oct 2018 09:38:34 GMT

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.

Re: Qlik Sense: Unable to sort number and text

wuming79 — Thu, 25 Oct 2018 05:50:45 GMT

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

My problem is fixed.

Re: Qlik Sense: Unable to sort number and text

McDonald-1022 — Fri, 21 Jun 2024 18:07:06 GMT

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