topic Re: How to use the if statement in QlikView

How to use the if statement

Anonymous — Mon, 31 Mar 2014 14:45:34 GMT

How to use the "If" statement with 3 possibilities in one expression?

Result expression 1 is a value (f.e. "2.7")

I've made 3 categories

"Good" if value < 2

"Normal" if value >=2 and ❤️

"Bad" if value >=3

How to make a new expression which shows me the value

"Normal" when exprssion 1 = 2.7

or which shows me

"Good" if expression 1 = 1.7

or shows me

"Bad" if expression 1 = 3.7

giakoum — Mon, 31 Mar 2014 14:48:14 GMT

if(exprssion 1 = 2.7, 'Normal', if(expression 1 = 1.7, "Good", if(expression 1 = 3.7, "Bad", "NA")))

alexandros17 — Mon, 31 Mar 2014 14:48:47 GMT

Here it is

If(value < 2, 'Good',

if(value >=2 and value <3, 'Normal' ,' Bad')

)

Hope it helps

its_anandrjs — Mon, 31 Mar 2014 14:50:49 GMT

Write like below

If(exprssion_1 = 2.7, 'Normal',

If(exprssion_1 = 1.7, 'Good',

If(exprssion_1 = 3.7,'Bad'))) as Result_expression

Hope this helps

Thanks & Regards

PrashantSangle — Mon, 31 Mar 2014 15:15:13 GMT

Hi,

Try this,

If(exprssion_1< 2, 'Good', if( exprssion_1<3, 'Normal' ,' Bad')) as Result

Regards,