Is there any handy way to make multiple search, like from a list?

[#1]

We need to search many product codes at a time, like from a long list. Is there any handy way to make this?

[ashfaq_haseeb · Accepted solution]

Yes,

have a look at attached application.

Regards

ASHFAQ

[jonathandienst]

Hi

If you mean to search in a list box, then construct a pipe separated string of the codes in Excel or a text editor, click on the list box and type* '(' followed by the list followed by a closing ')'

     for example: (code1|code2|code3)

HTH

Jonathan

* when you start typing, the search entry box should appear at the top of the list box

[#4]

Thx for fast reply! I managed to copy your solution into my application!

[#5]

Hello again,

I noticed that this input box works ok when used via IE Plugin from Accesspoint, but not if used with FullBrowser.

Any idea how to fix this?

best regards, timo v

[#6]

Hi Ashfaq,

The solution is excellent.Can you please explain a bit that how exactly it works?

Thanks

[ashfaq_haseeb]

Hi,

Its just work fine

I tried in desktop by enabling webview mode and in full browser version too.

it works, all you have to do is insert values in i/p box followed by space.

eg 20 50 then hit enter.

have a look at attached image.

What version of Qlik you use?

Regards

ASHFAQ

[ashfaq_haseeb]

Hi,

in the attached application there is variable event trigger added.

='(' & Replace(Replace(Replace(Trim('$(vCustomerList)'), '  ', '|'),' ', '|'), chr(10), '|') & ')'

which will search all values supplied to i/p  box.

Regards

ASHFAQ

[#9]

Hi,

I got it now.

Thanks

[#10]

Hi,

I think i have managed to copy and change all necessary variables/triggers, as all works nicely with client and also in accesspoint. Only when i put in client webview on, input box shows "undefinied" and when pasting a list copied from excel and press enter, it takes only the first row from my list. My QV version is 11.2 sr2, client, and all other as well

timo v