we can tell Tableau to generate a null when there isn't any data, and that's using the following table calculation: LOOKUP(SUM([Flag]),0).
This table calc returns SUM([Flag]) for the current row, and Null when no value is found. Then you can wrap that in the IIF(ISNULL()) operation to return 0 or a value. alternatively, you could just do the lookup and then Format the calculation to set 0 to be the Text for Special Values.
You can also refer the below post for your better understanding.
Yes but nothing happens . I want to hide the column from the visualization . The column should only appear if there is some value in calculation. Zero or null column shouldn't appear in visualization.
This only wraps zero to null or vice versa. What I m trying is to hide only column in a particular college that has zero or null values in it. I mean in visualization I shouldn't be able to see EB and UB for college CA as they are zero but I should be able to see them in college E.
- Create a calculation:
- This will return True, False and Null
- Drag it to Filter
- Set it to TRUE
Hope it Works!!!
There can be records with sum in negative
1 of 1 people found this helpful
If you need to Keep negative values, change the calculation to
- and set to TRUE in filter
Use the ISNULL() function. This will give you a True/False filter you can apply which will distinguish between null values and everything else. Set it to 'False' to remove all your nulls.
And the above strategy doesn't remove the column it keeps the column in visualization just doesn't show any bar to it or any annotation when hovered upon.