Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
jfung148
Contributor

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

Re: Negative Expression?

4 Replies
Chanty4u
Esteemed Contributor III

Re: Negative Expression?

may be try

with your requirment

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

Digvijay_Singh
Honored Contributor III

Re: Negative Expression?

Try this may be -

(*^A*)

Re: Negative Expression?

jfung148
Contributor

Re: Negative Expression?

this works perfectly thank you

thanks all