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
