From the course: Tableau 10: Mastering Calculations

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Return true or false values using IIF

Return true or false values using IIF - Tableau Tutorial

From the course: Tableau 10: Mastering Calculations

Start my 1-month free trial

Return true or false values using IIF

“

- [Instructor] In the previous movie, I showed you how to create conditional calculations using IF-THEN statements. The issue with most businesses, of course, is that you won't be faced with simple IF-THEN choices that much. You will probably have multiple conditions to test for. In this movie, I will show you how to define multiple conditions using IF-THEN-ELSE and ELSE-IF. My sample file is the ELSE-IF workbook and you can find it in the Chapter five folder of the Exercise Files collection. This workbook contains a single sheet with a table that displays Order ID and then the total value of the order. And what I'd like to do is to calculate any discounts that are available. I'll start up by creating two conditions. The first is if the value of the order is greater than $300, apply one discount level. If it's less than $300, apply another. To create this calculated field, I'll go to the analysis menu and click Create Calculated Field. Then in the calculation dialog box, I will change…

Contents