QlikView App Dev

[chinnu123]

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.

[swuehl]

Maybe

LOAD

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

     ...

FROM ...;

[chinnu123]

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 · Accepted solution]

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]

Try this ,

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