topic Re: Compound (multiple strings) search methods across two fields in QlikView

Compound (multiple strings) search methods across two fields

AndyA — Wed, 25 Nov 2020 16:16:04 GMT

We have two fields containing codes the front end users would like to free text search on, I’ve tried a couple of the methods, the search object and the search icon in the caption bar of a list box but none appear to work or easy to use. I use (combine) the two fields in either the search box or List box properties.

The two fields for demonstration purposes are

Search_Field_1 contains text in the format (example codes in one string) A020, E119, D573, H875, etc…….

Search_Field_2 contains text in the format (example codes in one string) Z272, D857, F968, L756, etc….

I would like the user to be able to type (in either the search text object or List Box search depending which method works best) E119 H875 Z272 and it matches the records. Unfortunately I can't get this to work. I’ve tried the“Use Wildcard Search” and “Use normal search” but they don’t appear to work, I’ve tried searching this and other sites for information but its conflicting and unclear on the format you have to use.

I’ve tried this format (*E119*|* H875*|* Z272*) but this would be unacceptable for the user to type in this format each time.

TIA

Andrew

Re: Compound (multiple strings) search methods across two fields

Nicole-Smith — Wed, 27 Nov 2019 19:54:21 GMT

You can paste values easier using an input box. See this thread for instructions on how to set that up: https://community.qlik.com/t5/QlikView-App-Development/Multiple-values-pasting-from-excel-to-Input-box-issue/m-p/1307393

Re: Compound (multiple strings) search methods across two fields

AndyA — Fri, 29 Nov 2019 13:33:08 GMT

Thank you for the response. I have considered using this method but the list of codes available is huge so its not practical.

Re: Compound (multiple strings) search methods across two fields

Nicole-Smith — Fri, 29 Nov 2019 13:55:02 GMT

I use the input box method to paste in large lists of values from Excel. I know we have users pasting in a few thousand values at a time.

Re: Compound (multiple strings) search methods across two fields

Brett_Bleess — Tue, 10 Dec 2019 18:31:12 GMT

Here are a couple of Help links, the first has the instructions regarding searching multiple list boxes:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Text_search_and_numeric_search.htm

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Multiple_selection_within_field.htm

Design Blog posts that may be of some help too:

https://community.qlik.com/t5/Qlik-Design-Blog/The-Search-String/ba-p/1470548

https://community.qlik.com/t5/Qlik-Design-Blog/The-Expression-Search/ba-p/1463907

Hopefully these will help confirm what does work/is supported such that you can find a method that works for you.

Regards,
Brett