Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
Honored Contributor

Re: search text within column values

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

Re: search text within column values

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
Honored Contributor

Re: search text within column values

Hi,

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

Regards,

Sokkorn

Community Browser