Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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 !!

Tags (4)
4 Replies
MVP
MVP

Re: NOT "FIELD"

[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

Re: NOT "FIELD"

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 ?

MVP
MVP

Re: NOT "FIELD"

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

MVP
MVP

Re: NOT "FIELD"

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