topic Re: Wildmatch on 2 words in QlikView

Wildmatch on 2 words

chiso_chiso — Wed, 15 Oct 2014 06:40:47 GMT

Hallo,

Is it possible to use wildmatch to filter items in a field with 2 or more words.

Attached is data sitting in my uploaded excel file as example.

For instance, 'availability' and 'Coke' to list all the availability of Coke.

chiso_chiso — Wed, 15 Oct 2014 06:42:14 GMT

Sorry I left the attachment out.

Thanks

alexandros17 — Wed, 15 Oct 2014 06:43:29 GMT

Wildmatch(MyField, 'Value1', 'Value2' ....) > 0 means that you have found at least a value among value1, value2 ... in the field MyField

chiso_chiso — Wed, 15 Oct 2014 07:01:18 GMT

For some reason my expression is not working

=if(WildMatch(Question,'*availability*','*coke*')>0, Answer)

PrashantSangle — Wed, 15 Oct 2014 07:06:31 GMT

Hi,

If you want Avaliabilty and Coke in same sentence

then write

if(Wildmatch(Question,'*availability*coke*'),Answer)

Regards

alexandros17 — Wed, 15 Oct 2014 07:10:27 GMT

Your syntax is absolutely correct, the reason could be that values are not contained in field Question,

have you some selection that exclude values, are you sure that question has that values?

chiso_chiso — Wed, 15 Oct 2014 07:15:09 GMT

I am using the attached data and have one expression in a straight table chart but still even with max dreamer's expression.

chiso_chiso — Wed, 15 Oct 2014 07:53:33 GMT

Sorry, I have figured it. I was using a wrong dimension but i should use the Question as dimension as well.

Thanks guys.