topic Re: Sort in QlikView

Sort

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

How to sort using the expression

iam using the below expression to sort accrodingly but i dont see the proper result , can someone help me with this

if(Priority='Blocker',1, if(Priority=' Critical',2, if(Priority=' High',3,if(Priority=' Medium',4,if(Priority=' Low',5,'Unassigned')))))

And this is what iam getting the output

Thanks in Advance

avinashelite — Mon, 05 Jun 2017 09:04:31 GMT

Add the expression in the sort >Expression > Increasing order >Number and uncheck rest

smilingjohn — Mon, 05 Jun 2017 09:12:29 GMT

Hi Avinash,

I dont see that increasing order in my list box propertiese

this is what i have

Siva_Sankar — Mon, 05 Jun 2017 09:18:59 GMT

use below in your expression

=Match(Priority,'Blocker','Critical','High','Medium','Low','Unassigned')

Siva

tresB — Mon, 05 Jun 2017 09:21:00 GMT

I see a space before your comparison strings. That could be causing the issue. Try removing them like:

if(Priority='Blocker',1, if(Priority='Critical',2, if(Priority='High',3,if(Priority='Medium',4,if(Priority='Low',5,'Unassigned')))))

Note: Change is like: ' Critical'->'Critical' // leading space removed.

Better solution could be using Match()

Match(Priority,'Blocker','Critical','High','Medium','Low','Unassigned')