topic Re: ApplyMaps/OR in the Load in QlikView

ApplyMaps/OR in the Load

leocattqv — Thu, 01 Mar 2018 20:13:27 GMT

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');

Re: ApplyMaps/OR in the Load

isingh30 — Thu, 01 Mar 2018 20:34:34 GMT

Please share your data or app.

Thank you!

Re: ApplyMaps/OR in the Load

el_aprendiz111 — Thu, 01 Mar 2018 20:45:56 GMT

Hi,

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

Re: ApplyMaps/OR in the Load

leocattqv — Thu, 01 Mar 2018 21:20:55 GMT

that did it, thanks Fer Fer