topic if condition in QlikView

if condition

Wed, 29 Feb 2012 16:59:33 GMT

Hello guys,

how to make this condition using if..else :

profit range between 1000 to 2000 then status is : acceptable.

profit range between 2000 to 3000 then status is : above average.

profit range between 3000 to 4000 then status is : exceeds expectation.

thanks

if condition

rajeshvaswani77 — Wed, 29 Feb 2012 17:21:15 GMT

if((prange>=1000 and prange<=2000), 'acceptable',if((prange>2000 and prange<=3000),'above average',if((prange>3000 and prange<=4000),'exceeds expectation','NA')))

if condition

jagan — Thu, 01 Mar 2012 05:06:15 GMT

Hi,

Use this expression

If (profitRange > 3000 AND profitRange <= 4000, 'exceeds expectation',

If (profitRange > 2000 AND profitRange <= 3000, 'above average',

If (profitRange > 1000 AND profitRange <= 2000, 'acceptable', 'N/A')))

Regards,

Jagan.

if condition

CELAMBARASAN — Thu, 01 Mar 2012 05:15:42 GMT

Hi,

I think this expression is enough for you.

If (profitRange > 3000, 'exceeds expectation',

If (profitRange > 2000 , 'above average',

If (profitRange > 1000, 'acceptable', 'N/A'))) [as FieldName] use this alias part if your using it in load script.

Celambarasan