KNOWLEDGE BASE

Filter Based on IIF Calculation Shows Unexpected Results


Published: 02 Dec 2015
Last Modified Date: 02 Sep 2016

Issue

When you have a calculated field based on an IIF calculation, the expected results might display differently based on the version of Tableau Desktop you are using. 

Environment

  • Tableau Desktop 9.1.0 - 9.1.4
  • Tableau Desktop 9.2.0 - 9.2.1

Resolution

Option 1:
Upgrade to Tableau Desktop 9.1.8, 9.2.2 or later version. For more information, see Upgrading Tableau Desktop.

Option 2:
Rewrite calculations to replace IIF() functions with IF/THEN/ELSE logic

Cause

This is a known issue which has been resolved in later versions of Tableau Desktop. 
Did this article resolve the issue?