Excluding values in set analysis

[youss123]

Hi all,

field1 : {value1, value2, value3}    field2:{valueA, valueB, valueC}

I want to exclude just the combinaision when field1 =value2 and field2 = valueC without deleting the other combinations

field 1        field2

_____________

value1      valueB

value1      valueC

value2       valueC

value2        valueA

value3         valueB

value3         valueC

count(distinct
{$ <
[field1] -= {"value2"} , [field2] -= {" valueC"}
>

}[KeyStay]

)

when I make it like this it delete all the fields with value2 and valueC.

Thank you for your help

[Kushal_Chawda · Accepted solution]

@youss123  try below

=count(distinct{<Field1 -= {'value2'}>+<Field2-={'valueC'}>}[KeyStay])

[youss123]

Hello @Kushal_Chawda 

I want to make the same thing with field 3 and 4 in the same set analysis but it didn't work.

=count(distinct{<Field1 -= {'value2'}>+<Field2-={'valueC'}

*

Field3 -= {'valueee2'}>+<Field4-={'valueeeC'}

>}[KeyStay])

field3 : {valueee1, valueee2, valueee3}    field4:{valueeeA, valueeeB, valueeeC}

I want to exclude also the combinaision when field3 =valueee2 and field2 = valueeeC 

field 3        field 4

_____________

valueee1      valueeeB

valueee1      valueeeC

valueee2       valueeeC

valueee2        valueeeA

valueee3         valueeeB

valueee3         valueeeC

Thank you for your help