topic Re: how to write case statement with COALESCE in QlikView

how to write case statement with COALESCE

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

Hi Team,

Can any one tell me how to write case statement with COALESCE in qlikview. please convert below below sql code in to qlik

CASE

WHEN (COALESCE(INCIDENT.Incident_ID,0) > 0)

THEN 'TRUE'

ELSE 'FALSE'

END AS FLAG,

Thanks,

Chinnu.

Re: how to write case statement with COALESCE

prma7799 — Fri, 03 Nov 2017 06:00:26 GMT

=if(INCIDENT.Incident_ID > 0, 'Yes', 'No' )

For checking null there is the isnull() function

where isnull(Incident_ID=0)

Re: how to write case statement with COALESCE

devarasu07 — Fri, 03 Nov 2017 06:03:43 GMT

Hi,

u can write like this,

if( INCIDENT.Incident_ID >0 , 'TRUE','FALSE') AS FLAG,

COALESCE mean not null values? if so then try like below,

if( INCIDENT.Incident_ID >0 and len(INCIDENT.Incident_ID)>0 , 'TRUE','FALSE') AS FLAG,

and also u can use below way for not null

Not IsNull(INCIDENT.Incident_ID)

Regards,

Deva

Re: how to write case statement with COALESCE

chinnu123 — Fri, 03 Nov 2017 06:22:02 GMT

Hi P M,

Thanks for your quick reply if I am using the above syntax I am getting only true values. I am not getting false values

Thanks,

Chinnu.

Re: how to write case statement with COALESCE

jonathandienst — Fri, 03 Nov 2017 06:38:31 GMT

For numerics, the equivalent function to SQL COALESCE in QV is Alt():

If(Alt(INCIDENT.Incident_ID, 0) > 0, 'TRUE', 'FALSE' )

Note that the QV is not totally the same as COALESCE because COALESCE works with non-numeric types as well, while the QV Alt() function only handles numerics.

Re: how to write case statement with COALESCE

prma7799 — Fri, 03 Nov 2017 07:12:57 GMT

as @jonatham suggest

Please try this

If(Alt(INCIDENT.Incident_ID, 0) > 0, 'TRUE', 'FALSE' )