Custom Filter(unusual range)

[#1]

I need to transform a field into a filter whight some custom range. So i need 3 different steps in one range filter, is it possible?

premius:

load

*,

if(premius=0 and premius=100,'100-500 $',

if(premius=100.1 and premius=500,'100.1-500 $',

if(premius= 500.1 and premius = 1000, '500.1-1000 $',

if(premius= 1000.1 and premius = 2000, '1000.1-2000 $',

.......         

if(premius= 29000.1 and premius = 30000, '29000.1-30000 $',

if(premius= 30000.1  and premius = 30000, '30000.1-40000 $',

......

if(premius= 100000.1  and premius = 150000, '100000.1-150000 $',

if(premius= 150000.1  and premius = 200000, '150000.1-200000 $',

'more 250000 $', premius&' $'))))))) as PremiusFilter

from premius.qvd

[#2]

Thank you it is what i need.

[MarcoWedel]

You're welcome.

Regards

Marco