Exclude certain values from a Field

[rsaeedga]

I am using Qlik Sense and have this question.

I have a  FIELD_A with values (A,B,C) . I would like to create a filter  with values Y and N.

Y should have (A,B,C) and N should have (A,B)

I have tried below

If(Not Match(FIELD_A,'C'),'N',

If(Match(FIELD_A,'A','B','C'),'Y')) as Filter

N works fine but not Y. Can someone help here pls

[joaopaulo_delco]

Hi @rsaeedga !

     I think the best wat to solve this problem is working creating a new dimension on script.

[rsaeedga]

I agree thats what I am trying to do but how I can. 

[AshutoshBhumkar]

Hello,

Do you have any sample data ?

We can actually try and create the dimension as per your question.

Thanks,

Ashutosh