topic Search string in QlikView

Search string

dbouilleux1 — Tue, 02 Aug 2011 10:27:12 GMT

Hello

In a field, I can have a series of values:
'abc', 'abd', 'abe', 'abf', 'abg', 'abh'

I want to get through action 'Select in Field', a selection that would
'abc', 'abf', 'abg', 'abh'.

I can write the search string ('abc' | 'abf' | 'abg' | 'abh'): it works.

But I wonder if it is possible to write the search string to say "All the values that start with 'ab', except 'abd' and 'abe"

Your ideas are welcome ....

Denis

Search string

swuehl — Tue, 02 Aug 2011 12:02:22 GMT

Hm,

I stumbled over this.

Then your expression could look like:

='=sum({<EnNo={'&chr(39)&'ab*'&chr(39)&'}-({'&chr(39)&'abd'&chr(39)&'}+{'&chr(39)&'abe'&chr(39)&'})>}1 )'

Regards,

Stefan

Search string

dbouilleux1 — Tue, 02 Aug 2011 12:34:30 GMT

Whoaouh ...

I would perhaps not find it right away ...

Thank you.

Denis

Search string

swuehl — Tue, 02 Aug 2011 12:43:25 GMT

The nasty thing is to encode the quotes. I used an expression with set expression to filter, but there maybe also other expressions that would work. The above technique opens your search string the QlikView expression world...

But without the mentioned thread, I would have had no clue either.

Have a nice day,

Stefan

Re: Search string

Tue, 05 Mar 2013 15:15:45 GMT

I need help, I need to find a string in a field. I have a field customer_type. if its value containg AD any where then I need to return Yes otherwise No.

PLs guide

Re: Search string

Wed, 06 Mar 2013 02:00:23 GMT

if(WildMatch(customer_type,'*AD*'),'Yes','No')as AD worked..