Wildmatch on 2 words

[chiso_chiso]

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]

Sorry I left the attachment out.

Thanks

[alexandros17]

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

[chiso_chiso]

For some reason my expression is not working

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

[PrashantSangle · Accepted solution]

Hi,

If you want Avaliabilty and Coke in same sentence

then write

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

Regards

[alexandros17]

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]

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]

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

Thanks guys.