Support in Set Analysis

[Rabia_Taimur]

I need to add check in set analysis where NonHiring is not equal to 1 (NonHiring<>1). I have tried multiple code but nothing is working. Tried below 3 bold codes, nothing is working. Appreciate urgent support please

Count
(
DISTINCT
{$
< Joining_Attr={">=$(=DATE(MAX(YearName(Joining_Attr,0,7))))"},

//NonHiring={"-=1"},
//NonHiring ={'*'} -{'1'},
//NonHiring -={'1'},

EmpTypeText-={'Trainees MPCL','MPCL Consultants'}
>
}
Emp_No
)

[Rabia_Taimur]

Seems like it wasn't working due to null values in field NonHiring. I have adjusted the null values in data load editor but would appreciate if anyone can share solution within Set Analysis

[Qrishna]

NonHiring -={1} should typically work.

[Rabia_Taimur]

Thank you!!!

Its working now after handling Null values. Sadly wasn't working with Null values in the field NonHiring

Thank you for your response!