topic Re: SQL CASE in Qlik in QlikView

SQL CASE in Qlik

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

Hello everybody,

I wanna this CASE statement translate in Qlik script.

CASE

WHEN Kontaktfehler =1 THEN 1

WHEN HSpgFehler =1 or HSpgFehlerW =1 THEN 2

WHEN Weg1 =1 or Weg1W =1 THEN 3

ELSE 0

END as Errorcode,

grateful for any help

Thanks.

Re: SQL CASE in Qlik

shiveshsingh — Wed, 07 Mar 2018 16:53:31 GMT

You can use If statement here or while loading from DB, you can use case there itself

Re: SQL CASE in Qlik

sunny_talwar — Wed, 07 Mar 2018 17:02:19 GMT

Should be like this

If(Kontaktfehler = 1, 1,

If(HSpgFehler = 1 or HSpgFehlerW = 1, 2,

If(Weg1 =1 or Weg1W =1, 3, 0))) as Errorcode

Modified my expression based on Shivesh's response

Re: SQL CASE in Qlik

Anonymous — Thu, 08 Mar 2018 08:15:31 GMT

Thank you, it works.

Let vToday = Floor(today()-180);

ODBC CONNECT TO viebjsql_daten;

K0_K1:

Load*, If(KontaktFehler = 1, 1,

If(HSpgFehler = 1 or HSpgFehlerW = 1, 2,

If(WegFehler1 =1 or WegFehler1W =1, 3, 0))) as Errorcode;

SQL SELECT *

FROM "PrfDat_ENTW".dbo."schuetzprf_K0_K1_agg1" WHERE "Prüfdatum" >$(vToday);

Re: SQL CASE in Qlik

shiveshsingh — Thu, 08 Mar 2018 08:37:37 GMT

Hi Sunny

There should be a comma also after 1 and 2 to make it else if..or it will work too..

If(Kontaktfehler = 1, 1 here

If(HSpgFehler = 1 or HSpgFehlerW = 1, 2 here

If(Weg1 =1 or Weg1W =1, 3, 0))) as Errorcode

Re: SQL CASE in Qlik

Anonymous — Thu, 08 Mar 2018 09:54:20 GMT

Yes comma is needed.

Re: SQL CASE in Qlik

sunny_talwar — Thu, 08 Mar 2018 10:02:03 GMT

Hahahaha yes, you are right... fixing my response now

Re: SQL CASE in Qlik

shiveshsingh — Thu, 08 Mar 2018 10:25:07 GMT

Great

Re: SQL CASE in Qlik

shiveshsingh — Thu, 08 Mar 2018 17:05:25 GMT

Glad to know it worked