How to implement not in filter for number field

Question & Answer
, ,
1

Hi Team,

Will be migrating stuff from tableau to QS, on tableau we can apply not in filter for number filter, how to implement same on QS at visual level

2

Hello @anshul1243

On the visual level you can add a filter based on the numeric field and set the condition as “not equal to” and set the value.

If you need to exclude multiple unique values or non-sequential values you could create a calculated field:

ifelse(
    {NumericField} <> 25 AND {NumericField} <> 32 AND {NumericField} <> 87,
    {NumericField},
    NULL
)