Qlik Community

Qlik Sense App Development

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

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
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 ?

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