CODEWITHSUNDEEP
if-statementtableau-api
RJayne
RJayne

Reputation: 15

Issue with an if statement for Tableau?

`IF[Lead Time] <= 4 THEN "0-4" 
ELSEIF [Lead Time] <= 18 THEN "5-18"
ELSEIF [Lead Time] <= 39 THEN "19-39"
ELSEIF [Lead Time] <= 69 THEN "40-69"
ELSEIF [Lead Time] <= 108 THEN "109-160"
ELSEIF [Lead Time] <= 160 THEN "161-239" 
ELSE [Lead Time] "239+" END`

I keep getting the "expected END to match IF at character 0". Can anyone see what is wrong with my code?

Upvotes: 1

Views: 132

Answers (1)

AnilGoyal
AnilGoyal

Reputation: 26218

try using this

IF [Lead Time] <= 4 THEN "0-4" 
ELSEIF [Lead Time] <= 18 THEN "5-18"
ELSEIF [Lead Time] <= 39 THEN "19-39"
ELSEIF [Lead Time] <= 69 THEN "40-69"
ELSEIF [Lead Time] <= 108 THEN "70-108"
ELSEIF [Lead Time] <= 160 THEN "109-160" 
ELSEIF [Lead Time] <= 239 THEN "161-239"
ELSE "239+" END

Upvotes: 1

Related Questions