topic Re: Im trying to do a multiple string search in button properties in QlikView

Im trying to do a multiple string search in button properties

Anonymous — Fri, 13 Dec 2013 18:20:15 GMT

Im trying to do a multiple string search in button properties, to make things worse, the strings also have spaces.

I could filter one search A. 10 - 15K but i can't join two together, i've tried piping them together and * for the spaces.

(A.*10*-*15K|B.*15*-*20K)

Much needed help

Many thanks in advance

Nicole-Smith — Fri, 13 Dec 2013 18:23:05 GMT

I believe you need to replace any special characters. I always replace mine with a question mark, but I wouldn't see why the * wouldn't work as well.

So try either:

(A*10*15K|B*15*20K)

(A??10???15K|B??15???20K)

Anonymous — Fri, 13 Dec 2013 18:32:40 GMT

Still not working, thanks

Fri, 13 Dec 2013 18:35:09 GMT

Have you tried putting double quotes around it like this ("A.*10*-*15K"|"B.*15*-*20K")

Nicole-Smith — Fri, 13 Dec 2013 18:37:28 GMT

Both options work for me (see the attached).

maxgro — Fri, 13 Dec 2013 18:40:02 GMT

try with

='("ba*"|"*de*")'

see attachments

Anonymous — Fri, 13 Dec 2013 18:40:51 GMT

Never worked, tbh i've tried so many variations, could the file be corrupt? it seems to be running fine, everything else is filtering through fine

Thanks anyway

Anonymous — Fri, 13 Dec 2013 18:45:30 GMT

Massimo you star!

Anonymous — Fri, 13 Dec 2013 18:48:13 GMT

Guys, i think all your suggestions work(mine worked on other files), some were working on my mates pc and not on mine.

maxgro — Fri, 13 Dec 2013 18:54:35 GMT

Nicole your example works for me too