topic Re: IF statement to categorize.. in QlikView

IF statement to categorize..

Anonymous — Wed, 26 Sep 2012 14:53:18 GMT

Hi,

i'm trying to categorize the using an If statement.

IF (Amount <= 200,'<=500',IF(Amount >500<1001,'501-1000',IF(Amount >1000>2000'1001-2000',null()) )) as AmountSize;

Please help .Thanks

billbois — Wed, 26 Sep 2012 15:16:58 GMT

I'm unable to test this at the moment, but I think it would be something like this:

IF (Amount <= 200, '<=500',

IF(Amount >500 AND Amount <1001, '501-1000',

IF(Amount >1000 AND Amount <2000, '1001-2000',

null()))) as AmountSize;

Hope this comes close.

MayilVahanan — Wed, 26 Sep 2012 15:36:20 GMT

IF (Amount <= 500, '<=500',

IF(Amount >500 AND Amount <1001, '501-1000',

IF(Amount <2000, '1001-2000',null()))) as AmountSize;

Hope it helps

Anonymous — Wed, 26 Sep 2012 15:49:24 GMT

script line error

Anonymous — Wed, 26 Sep 2012 16:09:41 GMT

sorry it worked,i had the same script in a different tab ,that's why i had the error

Thank you both