Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Negative Expression?

hi

i have a column that is a list of letters  (A///A,B///A,C,B,,,etc)

so i can do dropdown select and say *A* so i can select all the rows that contain the A letter..

how can i with dropdown select do all <> *A* or not contain A

how do i do that as an expression

thanks

1 Solution

Accepted Solutions
4 Replies
Chanty4u
MVP
MVP

may be try

with your requirment

=wildmatch(FIELD,'*A*') and not wildmatch(FIELD,'*B*','*C*)

Digvijay_Singh

Try this may be -

(*^A*)

tamilarasu
Champion
Champion

Hi Jackie,

Try: (*^*A*)

Compound Search - demystified

Anonymous
Not applicable
Author

this works perfectly thank you

thanks all