topic Re: Negative Expression? in QlikView

Negative Expression?

Anonymous — Mon, 19 Mar 2018 15:09:27 GMT

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

Chanty4u — Mon, 19 Mar 2018 15:30:17 GMT

may be try

with your requirment

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

Digvijay_Singh — Mon, 19 Mar 2018 15:30:44 GMT

Try this may be -

(*^A*)

tamilarasu — Mon, 19 Mar 2018 16:04:32 GMT

Hi Jackie,

Try: (*^*A*)

Anonymous — Mon, 19 Mar 2018 16:11:29 GMT

this works perfectly thank you

thanks all