Search string

[dbouilleux1]

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

[swuehl · Accepted solution]

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

[dbouilleux1]

Whoaouh ...

I would perhaps not find it right away ...

Thank you.

Denis

[swuehl]

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

[#5]

Hi

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

[#6]

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