Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

leocattqv
Contributor

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
Valued Contributor

Re: ApplyMaps/OR in the Load

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
Valued Contributor

Re: ApplyMaps/OR in the Load

Please share your data or app.

Thank you!

el_aprendiz111
Valued Contributor

Re: ApplyMaps/OR in the Load

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

leocattqv
Contributor

Re: ApplyMaps/OR in the Load

that did it, thanks Fer Fer