Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
leocattqv
Creator
Creator

ApplyMaps/OR in the Load

Hi All,

I have a dataset that needs a bunch of filtering - Im trying to do that filter in the load and Im not seeming to make it work.  Im working under the current Syntax - anyone have Ideas?  the Table isnt showing any records

Resident Complaints

Where Not WildMatch([Category],'Revision Surgery'

     OR [Item Number1],'99-*','RS*'

          OR [Failure], 'Damaged During Shipping'

               OR [SourceSite],'DoNotUse');

1 Solution

Accepted Solutions
el_aprendiz111
Specialist
Specialist

Hi,

Where Not WildMatch([Category],'Revision Surgery')
OR  WildMatch([Item Number1],'99-*','RS*')
OR  WildMatch([Failure], 'Damaged During Shipping')
OR  WildMatch([SourceSite],'DoNotUse');

View solution in original post

3 Replies
isingh30
Specialist
Specialist

Please share your data or app.

Thank you!

el_aprendiz111
Specialist
Specialist

Hi,

Where Not WildMatch([Category],'Revision Surgery')
OR  WildMatch([Item Number1],'99-*','RS*')
OR  WildMatch([Failure], 'Damaged During Shipping')
OR  WildMatch([SourceSite],'DoNotUse');

leocattqv
Creator
Creator
Author

that did it, thanks Fer Fer