Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

What is the logical operator for "NOT" in a search string?

Hello,

I've read some posts about search strings but couldn't find the NOT operator.

I would like to write a searchstring when I try to select some values in a listbox:

(*XXX* & "NOT" *Archive*)

My goal is to select all values from the field "FolderPath" that contain the string "XXX" but NOT the string "Archive".

What is the correct syntax for this?

,Thanks in advance, Koen

Message was edited by: Koen Bal

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

=Field like '*XXX*' and not Field like '*Archive*'

View solution in original post

13 Replies
Highlighted

Not sure I understand the requirement? Where are you using this?

Highlighted

Something like this ?

=if ( WildMatch ( 'BLAHappleBLAHlemonadeBLAH' , '*apple*' )

and not WildMatch ( 'BLAHappleBLAHlemonadeBLAH' , '*lemonade*' )

, 'Y' , 'N' )

=if ( WildMatch ( 'BLAHappleBLAHlemonadeBLAH' , '*apple*' )

and not WildMatch ( 'BLAHappleBLAHlemBLAHonadeBLAH' , '*lemonade*' )

, 'Y' , 'N' )

Highlighted
Specialist II
Specialist II

Test:

Load * inline

[

String_Field

ABCXXXDEFArchive

DEFArchiveABC

ABCXXX

XXXDEF

ABCXXXDEF

ArchiveABC

ABCArchive

];

Try the expression in list box:  if(wildmatch(String_Field,'*XXX*') and not WildMatch(String_Field,'*Archive*'),String_Field)

Highlighted
Partner
Partner

Are you looking something similar to this?

List box has 3 values and when I give -WD, WD has been filtered out.

exclude_selection.png

Highlighted
Champion
Champion

*XXX* & "NOT" *Archive* in same string?

Highlighted
Specialist III
Specialist III

Hi,

Try this

Search expression in listbox

Wildmatch(Filedname,'*XXX*') and not wildmatch(Fieldname,'*Archive*')

Highlighted
MVP
MVP

Try

("*XXX*" ^"*Archive*")

Highlighted

Never new about the ^ I'll remember that. 

Thanks.

Highlighted
Creator III
Creator III

Doesn't seem to work...