You try using the dual function to sort you values.
IF(A >=1 and A<1.25,Dual('iinteresting',1),
if(A>=1.25 and A<2.25,Dual('empty',2),
if(A>=2.25 and A<3.25,Dual('grandfather',3),
if(A>=3.25 and A<=4,Dual('nearly',4)))))
Sort this dimension by numeric. Best way to do this is, create this as a column in back script and use the field in front end as show in this attached post.
Hope this helps you.
Dual Sort.qvw 129.8 K