Announcements
cancel
Showing results for
Did you mean:
Creator

## Need help to convert in to qlik code

Hi Team,

CASE WHEN STATUS NOT IN ('07','10','22','AB')

THEN 'OPEN'

ELSE 'CLOSED'

END

AS Encryption.

Thanks,

Chinnu.

1 Solution

Accepted Solutions
MVP

Please note the comparison =0 with the match result.

Alternatively, use

If( not Match(STATUS,'07','10','22','AB'), 'OPEN','CLOSED') as Encryption,

5 Replies
MVP

Maybe

If( Match(STATUS,'07','10','22','AB')=0, 'OPEN','CLOSED') as Encryption,

...

FROM ...;

Creator
Author

Hi Stefan,

As per your syntax It takes the values if it match but I need where status not in

Thanks,

Chinnu.

MVP

Please note the comparison =0 with the match result.

Alternatively, use

If( not Match(STATUS,'07','10','22','AB'), 'OPEN','CLOSED') as Encryption,

MVP

Try only this

If(NOT Match(STATUS,'07','10','22','AB'), 'OPEN','CLOSED') as Encryption

From Location

ANd on UI as calculated dimension

=If(NOT Match(STATUS,'07','10','22','AB'), 'OPEN','CLOSED')

Creator

Try this ,

If(STATUS <> 07 or STATUS <> 10 or STATUS <> 22 or STATUS <> 'AB' , 'OPEN' ,'CLOSED') as Encryption

Community Browser