topic IF Statement with multiple conditions on a straight table in QlikView

IF Statement with multiple conditions on a straight table

ttwward — Wed, 28 Oct 2009 21:29:57 GMT

I have a straight table in which I have created variables. I want to use the value of the variables in a IF statement. I am not able to get the multiple if statament to work.

I have created variables under the expressions tab.

Check 1 = If (LR_Delq < .05, 'No Delqs', 'X') // If LR_Delq is less than .05 THEN put No Delqs as Check 1 value ELSE put X as check 1 value

Check 2 = IF (AEB < 1000000, 'Less than $1Mil', 'X') // If AEB is less than 1Mil then put Less than 1 Mil in Check 2 ELSE put X as the value in Check 2

Watch = IF ([Check 1] = 'X' AND [Check 2] = 'X', 'Watch', 'OK' ) // IF Check 1 and Check 2 have the value X then place Watch as the value ELSE record is ok and place OK in as the value in Watch

How can I check both conditions in one statement.

IF Statement with multiple conditions on a straight table

Wed, 28 Oct 2009 22:40:56 GMT

I don't see any issues there. Are you trying to display the Watch expression without the Check fields?

If so, try:

IF (LR_Delq >= .05 AND AEB >= 1000000, 'Watch', 'OK' )

It looks like Watch should display if both Check conditions are false, so I'm using the opposite of those consitionals. You could also switch around the True and False values in the equation and keep your same conditions.

IF (LR_Delq < .05 AND AEB < 1000000, 'OK', 'Watch')

Either of those should be equivilent to your statements.

IF Statement with multiple conditions on a straight table

Wed, 28 Oct 2009 22:50:48 GMT

Try this our

If(LR_Delq < .05, 'No Delqs',If(AEB < 1000000, 'Less than $1Mil','X'))

Talha