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.
