KNOWLEDGE BASE

Values for Calculated Field Based on Set Do Not Update As Expected


Published: 15 Jun 2016
Last Modified Date: 11 Jan 2018

Issue

When using a calculated field based on a set, values for the calculated field do not always update after the set is modified.
 

Environment

Tableau Desktop 10.4.0 and earlier versions

Resolution

Upgrade to Tableau Desktop 10.5.0 or a newer version. For more information, see Upgrade Tableau Desktop


If you are unable to upgrade, try one of the following workarounds: 

Option 1:

Refresh the extract to make the expected values appear.

Option 2:

Use a calculated field that mimics the behavior of the set, instead of a set.
 


Option 3:

Create a "Dummy Variable" that is inserted in a the formula for the Calculated Field, providing a 'direct reference' to a parameter.
For example,
Original formula:

       IF [Set 1] THEN [Sales] END

Where "Set 1" is a Set defined by a condition formula that references a parameter.
Revised formula: 

 IF [Set 1] THEN [Sales] END * [Parameter_One]

Where "Parameter_One" is a Parameter with a values of 1.




 

Cause

This behavior is related to a known issue with ID 667919 which has been corrected in more recent versions.



 

Additional Information


 
Did this article resolve the issue?