Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Search a Value from a Field in Another Field

Hello,

I have the following table:

IDDESC_COMPLETEDESC_REDUCED
001SECURITY - BROKEN SHIELDSECURITY
001CONTRACT - MISSING TAGSECURITY
001EXTRA - OTHERSSECURITY

What I want is to search the value in field DESC_REDUCED (SECURITY) in the field DESC_COMPLETE (over all the values) and bring the one that matches with the corresponding one (SECURITY - BROKEN SHIELD).

Is there any way to do that?

Thank you!!!

3 Replies
tresesco
MVP
MVP

Perhaps, you are talking about associative search. In the list box for DESC_COMPLETE right click->properties->General tab->Default Search Mode -> Set to 'Use Associative search'.

Not applicable
Author

Thanks, that would be useful if I had to select the value DESC_REDUCED. But I would like to have one single line in the table with the corresponding value and don't show the other ones.

tresesco
MVP
MVP

With default search mode - don't you get the similar? if you search 'SECURITY - BROKEN SHIELD' in the Desc_Complete field and press enter the single row with value gets selecetd to filter the associated security. Am I missing something?