topic SQL Coalesce statement in Qliksense in App Development

SQL Coalesce statement in Qliksense

j_qlikview — Sat, 16 Nov 2024 20:41:38 GMT

Hi,

How can i write the below statement in qliksense as iam not able to do it. It would be great if some one can help me on this.

COALESCE(SUM(LAST MONTH_AMOUNT),0) AS Payment;

Thanks in Advnace.

dplr-rn — Mon, 10 Jun 2019 18:19:21 GMT

You will need to use if statement something like
if(isnull(SUM(LAST MONTH_AMOUNT)),0,SUM(LAST MONTH_AMOUNT)) as Payment

dplr-rn — Mon, 10 Jun 2019 18:20:39 GMT

You can also try alt statement
alt(SUM(LAST MONTH_AMOUNT),0)
should yield same result

Channa — Tue, 11 Jun 2019 01:28:52 GMT

if(SUM(LAST MONTH_AMOUNT)=0,LAST MONTH_AMOUNT)