Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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-b...
Thank you for the response. I have considered using this method but the list of codes available is huge so its not practical.
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.
Here are a couple of Help links, the first has the instructions regarding searching multiple list boxes:
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