topic Re: How can I create a search box that accepts multiple inputs in csv format? in QlikView

How can I create a search box that accepts multiple inputs in csv format?

chiranjivdas — Wed, 21 Nov 2012 21:44:40 GMT

How can I create a search box that accepts multiple inputs in csv format?

Re: How can I create a search box that accepts multiple inputs in csv format?

MayilVahanan — Wed, 21 Nov 2012 21:53:14 GMT

Search like this

ex:

(zzz|yyy)

in search box..

or in button, use select in field option..

PFA

Re: How can I create a search box that accepts multiple inputs in csv format?

chiranjivdas — Wed, 21 Nov 2012 23:26:04 GMT

Thank you. actually values separated by space work; don't need the 'I'. The Select in Field option is not feasible because the list is long and the selection varies by users. So I just created a VB file that converts lists into space separated values. Users can then throw in the space separated values in the search box in QV and it works fine.

Re: How can I create a search box that accepts multiple inputs in csv format?

Gysbert_Wassenaar — Thu, 22 Nov 2012 11:37:12 GMT

See attached example. This was created by rebeccad and I've modified it a bit so it accepts comma separated lists too.

Re: How can I create a search box that accepts multiple inputs in csv format?

chiranjivdas — Thu, 22 Nov 2012 19:56:33 GMT

Thank you Gysbert! It works like a charm.

Re: How can I create a search box that accepts multiple inputs in csv format?

Sun, 09 Feb 2014 11:15:46 GMT

for some reason your example work fine in web mode

when i do it it doesn't work when i switch to web mode

Re: How can I create a search box that accepts multiple inputs in csv format?

Sun, 09 Feb 2014 11:19:42 GMT

i took your example i try to do it with numbers , doesn't work

Re: How can I create a search box that accepts multiple inputs in csv format?

Mon, 24 Mar 2014 12:09:55 GMT

Hi,

I have tried yout version and I fully understand the logic behind the search box - but for some reason I can't seem to dublicate it onto my own application model.

Do you have any suggestions as to what I should do when I already have the Graphs, models, tabels etc., and just need the functionality of yout Input box

Thanks in advance

Martin Palm