topic Re: Need help to convert in to qlik code in QlikView

Need help to convert in to qlik code

chinnu123 — Wed, 25 Nov 2020 16:16:04 GMT

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 — Sat, 09 Sep 2017 09:22:44 GMT

Maybe

LOAD

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

...

FROM ...;

chinnu123 — Sat, 09 Sep 2017 09:29:38 GMT

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 — Sat, 09 Sep 2017 09:32:03 GMT

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 — Sat, 09 Sep 2017 10:12:47 GMT

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 — Sat, 09 Sep 2017 10:32:57 GMT

Try this ,

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