Qlik Community

Ask a Question

Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

Announcements
Live Chat, June 29th 10AM ET. Bring your Qik Sense Enterprise, Client Managed questions! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
zied_ahmed1
Specialist
Specialist

Sorting by a field in a simple table qlik sense

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

1 Solution

Accepted Solutions
OmarBenSalem
Partner
Partner

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

View solution in original post

3 Replies
zied_ahmed1
Specialist
Specialist
Author

zied_ahmed1
Specialist
Specialist
Author

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
Partner
Partner

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

View solution in original post