topic Re: Sorting by a field in a simple table qlik sense in Management & Governance

Sorting by a field in a simple table qlik sense

zied_ahmed1 — Tue, 16 Oct 2018 15:21:15 GMT

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 — Tue, 16 Oct 2018 15:55:31 GMT

zied_ahmed1 — Tue, 16 Oct 2018 16:00:58 GMT

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 — Tue, 16 Oct 2018 17:21:18 GMT

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