Sorting order in Qliksense- Straight table

[ReddyQsQv]

Value	ID	Status
Test1	1	Green
Test2	1	Amber
Test3	1	Amber
Test1	2	Green
Test2	2	Amber
Test3	2	Red

My Data is like above , In which the status should be sorted in the order of  Red--->Amber--->Green

The result should shown like below:

Value	ID	Status
Test3	2	Red
Test2	2	Amber
Test3	1	Amber
Test2	1	Amber
Test1	2	Green
Test1	1	Green

[joseto00]

Hello! You have to assign a number to each color and use this assignment in the order

     = if (Status ='Red',1, if (Status ='Amber',2,if (Status ='Green',3)))

[Sameer9585]

In properties panel,goto sorting section and in it select  the feild 'Status' and in sort by expression and write as below

pick(match(Status,Red,Amber,Green),1,2,3)

and select 'ascending'

this helps.

[ReddyQsQv]

Its not working

[Sameer9585]

I want to see how you entered the expression can you please share screen shot or the qvf file if possible

[Sameer9585]

Hi @ReddyQsQv ,

You should bring the 'status' to criteria '1' and give the expression as this   pick(match(Status,'Red','Amber','Green','N/A'),1,2,3,4)

I'm attaching the qvf file check it.

Thanks,