Discussion Board for collaboration related to QlikView App Development.
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
Go to Solution.
Compound Search - demystified
View solution in original post
may be try
with your requirment
=wildmatch(FIELD,'*A*') and not wildmatch(FIELD,'*B*','*C*)
Try this may be -
this works perfectly thank you