topic Re: search text within column values in QlikView

search text within column values

Thu, 23 May 2013 07:48:03 GMT

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

Re: search text within column values

Sokkorn — Thu, 23 May 2013 07:53:57 GMT

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

Re: search text within column values

Thu, 23 May 2013 08:01:04 GMT

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

Re: search text within column values

Sokkorn — Thu, 23 May 2013 08:04:08 GMT

Hi,

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

Regards,

Sokkorn