Ultimate Tableau Desktop Course - Beginner to Advanced Bundle - Conditional Expressions

This video tutorial covers various logical functions in Tableau, including IIF, IF ELSE, IF ELSE IF, and CASE WHEN. It explains how to use these functions to perform conditional logic on data, create calculated fields, and categorize data based on specific conditions. The tutorial provides practical examples, such as creating an 'Alert' field to indicate stock levels and categorizing products into different groups. It also highlights the differences between these functions and their syntax, helping users choose the appropriate function for their needs.

What is the primary purpose of the IIF function in Tableau?

• To create visualizations

• To check conditions and return values

• To import data

• To export reports

Which of the following is NOT a comparison operator in Tableau?

• Equal to

• Less than

• Multiply by

• Greater than

How does the IF ELSE function differ from the IIF function?

• It is used for data import

• It cannot handle conditions

• It uses keywords instead of commas

• It uses commas instead of keywords

What keyword signifies the end of an IF ELSE expression?

• Close

• Finish

• Stop

• End

What is a key feature of the IF ELSE IF function?

• It can only handle one condition

• It is used for exporting data

• It allows multiple conditions

• It does not return any value

Which logical operator ensures that at least one condition is true in an IF ELSE IF expression?

• EQUAL

• NOT

• AND

• OR

What does the CASE WHEN function primarily evaluate?

• A single expression

• Multiple conditions

• Data import

• Visualization settings

What is a limitation of the CASE WHEN function?

• It requires multiple expressions

• It cannot return values

• It is not available in Tableau

• It can only handle one condition

In the CASE WHEN function, what happens if no match is found and no default return is set?

• The function returns an error

• The function returns null

• The function stops execution

• The function returns zero

What is the purpose of assigning category IDs using the CASE WHEN function?

• To export reports

• To create visualizations

• To categorize products

• To import data