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: 
chinnu123
Creator
Creator

Need help to convert in to qlik code

Hi Team,

please help me to convert below code to qlik

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

                     THEN 'OPEN'

                     ELSE 'CLOSED'

  END

AS Encryption.


Thanks,

Chinnu.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Please note the comparison =0 with the match result.

Alternatively, use

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

View solution in original post

5 Replies
swuehl
MVP
MVP

Maybe

LOAD

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

     ...

FROM ...;

chinnu123
Creator
Creator
Author

Hi Stefan,

Thanks for your quick reply,

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

Thanks,

Chinnu.

swuehl
MVP
MVP

Please note the comparison =0 with the match result.

Alternatively, use

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

its_anandrjs

Try only this

Load

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')


rohitraut
Creator
Creator

Try this ,

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