If Then statement - Tableau with multiple conditions

Question

If, Then, ElseIf statement with two fields where one field has two values to be TRUE

The Lead Age and Lead Status where two statuses and both of them should be true. Tried OR, tried AND, tried adding parenthesis.

IF [Lead Age] >3 AND [Lead Status] = "A. Open" THEN "Open"

ELSEIF ([Lead Status] = "B. Attempting to Contact" OR [Lead Status] = "C. Contacted") AND [Lead Age] >30 THEN  "Inactive"

ELSEIF ([Lead Status] = "B. Attempting to Contact" OR [Lead Status] = "C. Contacted") AND [Lead Age] <30 THEN  "Active"

ELSEIF [Lead Status] = "N. Nurture" OR [Lead Status] ="Disqualified" THEN  "Disqualified"

ELSE "Other"

END

Expected Result ->

If Lead Status is Attempting to Contact and also Lead Status is Contacted, add both statuses where Lead Age is also >30 days

I tried the below as well:

IF [Lead Status] = "N. Nurture" OR [Lead Status] ="Disqualified" THEN  "Disqualified"

ELSEIF ([Lead Status] = "B. Attempting to Contact" AND [MQL Age] >30) OR ([Lead Status] = "C. Contacted" AND [MQL Age] >30) THEN  "Inactive"

ELSEIF ([Lead Status] = "B. Attempting to Contact" AND [MQL Age] <30) OR ([Lead Status] = "C. Contacted" AND [MQL Age] <30) THEN  "Active"

ELSEIF ([Lead Status] = "A. Open" AND [MQL Age] >3) THEN "Open"

ELSE "Other"

END

Pooja Sharma Pooja Sharma · Accepted Answer · 2019-06-06T18:09:46

Below condition works for me:

If ([Lead Age] > 30 and 
([Lead Status] = 'Attempting to Contact' or [Lead Status] = 'Contacted')) THEN
'Yes'
ELSE
'No'
END

If Then statement - Tableau with multiple conditions

1 Answers