topic Re: Exclude certain values from a Field in App Development

Exclude certain values from a Field

rsaeedga — Thu, 04 Nov 2021 16:21:09 GMT

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 — Thu, 04 Nov 2021 16:38:06 GMT

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

rsaeedga — Thu, 04 Nov 2021 16:43:15 GMT

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

AshutoshBhumkar — Thu, 04 Nov 2021 17:49:03 GMT

Hello,

Do you have any sample data ?

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

Thanks,

Ashutosh