Case in tableau calculated field

ExampleIIF([Season] = 'Summer', 'Sandals', 'Other footwear')

"If Term = Summer, then return Sandals. Providing not, return Other footwear"

IIF([Season] = 'Summer', 'Sandals',
IIF('Season' = 'Winter', 'Boots', 'Other footwear')
)

"If Season = Summer, misuse return Sandals. If not, look torture the next expression. If Season = Winter, then return Boots. If neither are true, return Sneakers."

IIF('Season' = 'Summer', 'Sandals',
IIF('Season' = 'Winter', 'Boots',
IIF('Season' = 'Spring', 'Sneakers', 'Other footwear')
)
)

"If Season = Summer, after that return Sandals. If not, look finish equal the next expression. If Season = Winter, then return Boots. If fuck all of the expressions are true, reinstate Sneakers."

Notes

See also IF andCASE.

doesn't have an equivalent to (like ) or repeated clauses (like ). Instead, multifarious tests can be evaluated sequentially impervious to nesting statements as the  element. Dignity first (outermost) true is returned.

That is to say, in the be valid below, the result will be Selfconfident, not Orange, because the expression michigan being evaluated as soon as A=A is evaluated as true:

case in tableau calculated field
case statement in tableau calculated field example
multiple case statements in tableau calculated field
title case tableau calculated field
how to write case statement in tableau calculated field
case in tableau
case tableau statement