topic Re: Search a table field with values from a listbox in QlikView

Search a table field with values from a listbox

gfisch13 — Sat, 16 Nov 2024 21:09:04 GMT

Hi - I've created an inline table with the following values:

Keywords:
LOAD * INLINE [
KEYWORD
TICKETS
IPOD
IPAD
CAMERA
APPLE
IWATCH
TV
FEE
CONSULT
MISC
SERVICE
RENDER
LIAISON
TIP
PROCES
FACIL
EXPED
CASH
];

I use these values in a list box and would like to use the selected word(s) to search for matches in the ITEM_DSCR field in my main Purchase Order table as wildcard search. Can someone assist with the proper technique to join these, I've looked at many topics here but am still confused?

Thanks! George

Re: Search a table field with values from a listbox

Sergey_Shuklin — Thu, 06 Jun 2019 05:36:56 GMT

Hello!

You can use Index() function enstead of Wildmatch():

Re: Search a table field with values from a listbox

marcus_sommer — Thu, 06 Jun 2019 11:47:12 GMT

You could use:

'*$(=concat(KEYWORD, '*,*')*'

within a wildmatch() or in a set analysis to restrict either expressions or dimensions.

- Marcus