Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
dbouilleux1
Partner - Contributor
Partner - Contributor

Search string

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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

View solution in original post

5 Replies
swuehl
MVP
MVP

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
Partner - Contributor
Partner - Contributor
Author

Whoaouh ...

I would perhaps not find it right away ...

Thank you.

Denis

swuehl
MVP
MVP

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

Not applicable

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

Not applicable

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