Spotfire Ideas Portal
When the condition for != or <> is filtered on, it should not filter out null/empty values unless it was specified in the condition. For example, if there is a field called "Number" with a list of numbers 1,2,3,4,5,6,,7,8 (null between 6 and 7). Then [Number]!=7 should have 1,2,3,4,5,6,,8 (Null included). Not 1,2,3,4,5,6,8 (Null excluded).
Thank you for this suggestion.
It aligns with an expectation that null/empty values are distinct from any specific value unless specified otherwise in the filter logic.