Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
use below in your expression
=Match(Priority,'Blocker','Critical','High','Medium','Low','Unassigned')
for other methods of custom sorting refer here http://www.qlikfix.com/2010/10/25/creating-a-custom-sort-order/
Siva
Add the expression in the sort >Expression > Increasing order >Number and uncheck rest
Hi Avinash,
I dont see that increasing order in my list box propertiese
this is what i have
use below in your expression
=Match(Priority,'Blocker','Critical','High','Medium','Low','Unassigned')
for other methods of custom sorting refer here http://www.qlikfix.com/2010/10/25/creating-a-custom-sort-order/
Siva
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')