topic IF statement between value with specific need for 0 only in QlikView

IF statement between value with specific need for 0 only

Tue, 18 Dec 2012 15:48:53 GMT

Hello;

Looking for help with this basic IF statement.

I would like the system to report the following:

If the value is equal to zero mark it as 0.

If the value is bigger than 1.5 mark it as 1.

If the value is samller than 0.3 mark it as 1.

If the value is in between 0.3 and 1.5 mark it as 0.

I have tried if(value=0 and value>0.3 and value<1.5,0,1)

Not returning what I am looking for.

Thanks in advance for your answer.

Kristel

Gysbert_Wassenaar — Tue, 18 Dec 2012 15:51:10 GMT

try if( (value>0 and value<0.3) or value >1.5,1,0)

Tue, 18 Dec 2012 16:01:43 GMT

MANY THANKS!!!!!!!