Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Applicable88
Creator III
Creator III

If and match combination to exempt values

Hello, 

I tried used a qlik switch module to look for certain certain numbers.

Now I want to use a Qlik Switch to exempt certain codes like this, that means I want to see all other codes except for D555:

 

=aggr(if(match([Failure - Code],'D555')<>0, Faulure Problem),Report)

but it still displays value with the code D555.

I also tried:

=aggr(if(match([Failure - Code],'D555)<>0, 0),Report)

Still doesn't filter correctly, still see reports with that code.

Maybe I didn't wrote the syntax right?

Hope someone knows. 

Thanks in advance. 

 

1 Solution

Accepted Solutions
Qlik1_User1
Specialist
Specialist

Try this

=aggr(if(NOT match([Failure - Code],'D555')<>0, Faulure Problem),Report)

View solution in original post

1 Reply
Qlik1_User1
Specialist
Specialist

Try this

=aggr(if(NOT match([Failure - Code],'D555')<>0, Faulure Problem),Report)