Logical functions (IF, IIF, CASE) in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ dax_lod_result

intermediate

Output of nested IF statement in Tableau calculated field

Consider this Tableau calculated field:

IF [Sales] > 1000 THEN 'High' ELSEIF [Sales] > 500 THEN 'Medium' ELSE 'Low' END

What will be the result for a record where Sales = 750?

Tableau

IF [Sales] > 1000 THEN 'High' ELSEIF [Sales] > 500 THEN 'Medium' ELSE 'Low' END

A 'High'

B NULL

C 'Low'

D 'Medium'

💡 Hint

Think about the order of conditions and which one matches first.

Since 750 is not greater than 1000, the first condition fails. The second condition checks if Sales is greater than 500, which is true, so the result is 'Medium'.

❓ visualization

intermediate

Best visualization to show CASE statement categories

You have a calculated field using CASE to categorize customers by region:

CASE [Region]
WHEN 'East' THEN 'Group 1'
WHEN 'West' THEN 'Group 2'
ELSE 'Group 3'
END

Which visualization best shows the count of customers in each group?

A Scatter plot of customer age vs sales

B Line chart showing customer count over time

C Pie chart showing percentage of customers per group

D Text table listing customer names

💡 Hint

Think about how to show parts of a whole clearly.

A pie chart clearly shows the proportion of customers in each group defined by the CASE statement.

🧠 Conceptual

advanced

Difference between IF and IIF in Tableau

Which statement correctly describes the difference between IF and IIF functions in Tableau?

A IF is only for numeric comparisons, IIF is for text comparisons

B IIF evaluates both true and false parts always, IF evaluates only the matching part

C IIF can only be used inside calculated fields, IF cannot

D IF returns a Boolean, IIF returns a string

💡 Hint

Consider how each function processes its arguments.

IIF evaluates both the true and false expressions regardless of the condition, which can affect performance or cause errors if one side is invalid. IF evaluates only the branch that matches the condition.

🔧 Formula Fix

advanced

Identify error in CASE statement syntax

What error will this Tableau calculated field produce?

CASE [Category]
WHEN 'A' THEN 1
WHEN 'B' THEN 2
ELSE 3

Tableau

CASE [Category]
WHEN 'A' THEN 1
WHEN 'B' THEN 2
ELSE 3

A Syntax error: missing END keyword

B Runtime error: invalid ELSE clause

C No error, runs correctly

D Type error: mixing string and number

💡 Hint

Check if the CASE statement is properly closed.

Tableau CASE statements must end with END. Missing END causes a syntax error.

🎯 Scenario

expert

Using nested logical functions for complex categorization

You want to create a calculated field in Tableau that categorizes sales performance as:
- 'Excellent' if Sales > 1000 and Profit > 200
- 'Good' if Sales > 1000 and Profit ≤ 200
- 'Average' if Sales ≤ 1000 and Profit > 100
- 'Poor' otherwise

Which calculated field expression correctly implements this logic?

A CASE WHEN [Sales] > 1000 AND [Profit] > 200 THEN 'Excellent' WHEN [Sales] > 1000 AND [Profit] <= 200 THEN 'Good' WHEN [Sales] <= 1000 AND [Profit] > 100 THEN 'Average' ELSE 'Poor' END

B IF [Sales] > 1000 THEN IF [Profit] > 200 THEN 'Excellent' ELSE 'Good' END ELSEIF [Profit] > 100 THEN 'Average' ELSE 'Poor' END

C IIF([Sales] > 1000, IIF([Profit] > 200, 'Excellent', 'Good'), IIF([Profit] > 100, 'Average', 'Poor'))

D IF [Profit] > 200 THEN 'Excellent' ELSEIF [Sales] > 1000 THEN 'Good' ELSEIF [Profit] > 100 THEN 'Average' ELSE 'Poor' END

💡 Hint

Check that all conditions match the exact logic and order.

Option A uses CASE with combined conditions matching the exact logic. Other options either misorder conditions or do not fully match the logic.