Qlik Community

Qlik Sense Deployment & Management

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

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
zied_ahmed1
Valued Contributor

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

Re: Sorting by a field in a simple table qlik sense

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

3 Replies
zied_ahmed1
Valued Contributor

Re: Sorting by a field in a simple table qlik sense

zied_ahmed1
Valued Contributor

Re: Sorting by a field in a simple table qlik sense

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

Partner
Partner

Re: Sorting by a field in a simple table qlik sense

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