Match sort not working as anticipated

[orangebloss]

I have two tables which need to be sorted in a specific order.  One table I've managed to sort but the second doesn't seem to want to despite doing exactly the same thing - albeit with different fields. Can anyone spot why this might be?

I've check spellings and spaces so it's not that?

How the table is appearing (note some of the items are off the page):

Match statement:

The table that is sorting correctly is set up as below:

**EDIT: I've noticed that one of the fields in the first table is also in the wrong place, but only one 'Mods due to other reasons' any insight much appreciated!

[SunilChauhan]

uncheck sort numerically in both .

[MatheusC · Accepted solution]

Choose numerical ratings.
In your script, you can return the number of rows in your table using the RowNo() function, so each row is a Sequence.

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/InterReco....

Load
RowNo() as Seq

In the table, place your ScorecarMeasure dimension and the new numeric field (Seq), to see the sequence of each of your dimensions. And place it in your sort tab as you were doing, but now sort by the sequence of numbers you want to view:

Match(Seq, '1', '4', '5', '2', '3'…)

Regarts, Matheus