Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
gfisch13
Contributor

Search a table field with values from a listbox

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

Tags (3)
Labels (2)
2 Replies
Sergey_Shuklin
Valued Contributor

Re: Search a table field with values from a listbox

Hello!

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

wildmatch_keyword_pic1.png

MVP & Luminary
MVP & Luminary

Re: Search a table field with values from a listbox

You could use:

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

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

- Marcus