Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
rsaeedga
Contributor II
Contributor II

Exclude certain values from a Field

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

3 Replies
joaopaulo_delco
Partner - Creator III
Partner - Creator III

Hi @rsaeedga !

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

Help users find answers! Don't forget to mark a solution that worked for you!
rsaeedga
Contributor II
Contributor II
Author

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

AshutoshBhumkar
Partner - Specialist
Partner - Specialist

Hello,

Do you have any sample data ?

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

Thanks,

Ashutosh