Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jfung148
Creator
Creator

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
tamilarasu
Champion
Champion

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

jfung148
Creator
Creator
Author

this works perfectly thank you

thanks all