topic Re: IF Statement in Expression with multiple between statements in QlikView

IF Statement in Expression with multiple between statements

Thu, 08 Jan 2015 18:21:50 GMT

Hi,

I'm have difficulty creating an expression that will evaluate another expression and assign a point value based on a range of values.

Here is what Im trying to do

IF [ExpressionName] is between Value1 & Value2 return '1'

IF [ExpressionName] is between Value3 & Value4 return '2'

IF [ExpressionName] is between Value5 & Value6 return '3'

IF [ExpressionName] is greater than Value7 return '4'

This should be all contained in one expression and the values will need to be hard coded Can someone please provide some guidance/help?

Thanks.

Brian

Re: IF Statement in Expression with multiple between statements

jerem1234 — Thu, 08 Jan 2015 18:27:02 GMT

Something like:

if([ExpressionName]<Value1, 0,

if([ExpressionName]>=Value1 and [ExpressionName] <Value2, 1,

if([ExpressionName]>=Value2 and [ExpressionName] < Value3, 2,

if([ExpressionName]>=Value3 and [ExpressionName] <Value4, 3,

if([ExpressionName]>=Value4, 4

)))))

Hope this helps!

Re: IF Statement in Expression with multiple between statements

Fri, 09 Jan 2015 14:59:06 GMT

Thanks, works perfectly.

Re: IF Statement in Expression with multiple between statements

MarcoWedel — Fri, 09 Jan 2015 16:30:29 GMT

Hi,

another solution could be:

Match(-1,
      vExpressionName >= 1 and  vExpressionName <= 2,
      vExpressionName >= 3 and  vExpressionName <= 4,
      vExpressionName >= 5 and  vExpressionName <= 6,
      vExpressionName >= 7)

hope this helps

regards

Marco