SQL Coalesce statement in Qliksense

[j_qlikview]

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.

J

[dplr-rn · Accepted solution]

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

[dplr-rn · Accepted solution]

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

[Channa]

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