Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
orangebloss
Creator
Creator

Match sort not working as anticipated

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):

orangebloss_0-1716283743503.png

orangebloss_1-1716283795383.png

Match statement:

orangebloss_2-1716283830390.png

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

orangebloss_3-1716283930491.pngorangebloss_4-1716283946400.png

orangebloss_5-1716283976106.png

**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!

 

 

 

Labels (2)
1 Solution

Accepted Solutions
MatheusC
Specialist II
Specialist II

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

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!

View solution in original post

2 Replies
SunilChauhan
Champion II
Champion II

uncheck sort numerically in both .

Sunil Chauhan
MatheusC
Specialist II
Specialist II

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

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!