If statement with data range

Fri, 16 Nov 2012 21:50:11 GMT

I am wondering if it is possible to have this type of if statement:

if (field_b between 0 and 100 than field_d = A), else if (field_b between 101 and 1000 than field_d = B), else if etc.

Can I do it in qlikview?

Many thanks in advance

Re: If statement with data range

MayilVahanan — Fri, 16 Nov 2012 21:54:46 GMT

Try like this

Load *, if(field_b >= and field_b <= 100, 'A', if(field_b >=101 and field_b <= 1000,'B','C')) as field_d from tablename;

Hope it helps