Sorting by a field in a simple table qlik sense

[zied_ahmed1]

Hello I have a a simple table with these fields :

First Name Last Name Priority

The Priority field is Hight Medium Low

I need to do sorting with Priority but how to display like High first Medium Second and Low Third

Example :

Name Last Name Priority

X              Y              Hight

Z               N             Medium

N               H              Low

Thanks for answer

[zied_ahmed1]

stalwar1‌ omarbensalem‌

[zied_ahmed1]

Hello,

I find a solution but i don't know if it's correct but i tried it for many examples and it works...

In the sorting column i added this like an expression :

Priority='High' or Priority = 'Medium'

Thanks

[OmarBenSalem · Accepted solution]

Create an inline table :

load * inline [

Priority, PriorityId

High, 3

Medium, 2

Low, 1

];

and sort ur table by expression; put  as an expression : PriorityId desc