KNOWLEDGE BASE

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


Published: 15 Jun 2016
Last Modified Date: 30 Nov 2019

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

Option 1

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

Option 2

If you are unable to upgrade, try one of the following workarounds: 
  1. Refresh the extract to make the expected values appear.
  2. Or, use a calculated field that mimics the behavior of the set, instead of a set.
  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.



 
Did this article resolve the issue?