Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

search text within column values

hi all,

i need to search a text from a column see below by using expression:

column

abc

exf

ght

daf

raf

need to search 'a' text from column using expression .

please share with me the syntax

thanks

3 Replies
Sokkorn
Master
Master

Hi,

I think we don't need to write an expression because Search object will do this job (native function). Create new Search object and choose your column to search. When you type 'a', all data related to 'a' will hightligh for you.

Regards,

Sokkorn

Not applicable
Author

agreed but i need to make a report and this expression column needs to be in straight table so please advise syntax for the expression

thanks

Sokkorn
Master
Master

Hi,

WildMatch() function maybe can help. Let try WildMatch(Column,'*a*')

Regards,

Sokkorn