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: 
Not applicable

NOT "FIELD"

Hello,

I try to write this condition :

FIELD1 équal 'AM' and FIELD2 without 'TERA'

So i tried to write :

[FIELD1] = 'AM' and [FIELD2] <> 'TERA'

But it doesn't work

Someone know how to do a NOT in a condition ?

Thanks in advance !!

4 Replies
swuehl
MVP
MVP

[FIELD1] = 'AM' and NOT [FIELD2] = 'TERA'


but I would have assumed your expression to work also. How do your field values look like and in which context are you using this expression?

Not applicable
Author

My complete sentence is

OSW = TAI with 0 time left  - AM without TERA - MQ - CO

So i try to write

if([TAI Restant (h)]='0,0000' (OR Type = 'QN-AM' AND NOT [Statut Utilisateur] like '*TERA*' ) AND NOT Type like 'LP-MQ' AND NOT Type like 'CO-CO' ,'OSW')

But it doesn't work do you have a better solution ?

sunny_talwar

Would you be able share few rows of data to see what exactly you are trying to do with the logic above?

swuehl
MVP
MVP

I don't think the first part is correct syntax (or you may need to change the parentheses:

if( [TAI Restant (h)]='0,0000' OR ( Type = 'QN-AM' AND NOT [Statut Utilisateur] like '*TERA*' )...


or maybe


if( ( [TAI Restant (h)]='0,0000' OR ( Type = 'QN-AM' AND NOT [Statut Utilisateur] like '*TERA*' ) )...


or something else