topic Dynamic Wildmatch expression in QlikView

Dynamic Wildmatch expression

stevegimbrollmt — Tue, 26 Nov 2013 16:49:33 GMT

Hi ladies and gents,

I was wondering what is the best approach to take to create a WildMatch search using WildMatch or Like to filter from a list that would be retrieved from a text file. so I would do something like WildMatch.

I have found a similar question but it does not work. Not sure what is wrong with it.

http://community.qlik.com/message/363088#363088

Can someone give me a helping hand please

Regards

Steve

Re: Dynamic Wildmatch expression

Clever_Anjos — Tue, 26 Nov 2013 16:59:01 GMT

Try something like this

Patterns:
LOAD * INLINE [
    F1
    8989
    11231
    123123
    13123
    13
    43534
];
List:
LOAD
chr(39)&Concat(F1&'*',chr(39)&','&chr(39))&chr(39) as List
Resident Patterns;
LET Pattern=Peek('List');


Load
  WildMatch(yourfield,$(Pattern))
from yourqvd(qvd).

Re: Dynamic Wildmatch expression

stevegimbrollmt — Sat, 07 Dec 2013 15:41:50 GMT

thanks a lot for the help.

It works