topic How to calculate Null value as 0 in expression while using sum or aggr function in QlikView https://community.qlik.com/t5/QlikView/How-to-calculate-Null-value-as-0-in-expression-while-using-sum/m-p/194399#M55313 <HTML><HEAD></HEAD><BODY><P>How to check and replace the null values with 0 where the expression results are returning the null values from the aggr(sum) function.</P><P>For example: I am trying to calculate if(aggr(sum(sales), customer &gt; 0 and sum(sales, customer &lt;= 0, 'LOST') now here the condition is not getting true since there may be NULL values obtained by the result of this expression. So I would like to replace the null values with zeros so that this condition is always evaluated as true when values are zero or null.</P><P>I hope you got my problem. Please advise the solution asap.</P><P>Thanks and Regards</P><P>Sajid Mahmood</P></BODY></HTML> Fri, 18 Jun 2010 20:26:07 GMT Sajid_Mahmood 2010-06-18T20:26:07Z How to calculate Null value as 0 in expression while using sum or aggr function https://community.qlik.com/t5/QlikView/How-to-calculate-Null-value-as-0-in-expression-while-using-sum/m-p/194399#M55313 <HTML><HEAD></HEAD><BODY><P>How to check and replace the null values with 0 where the expression results are returning the null values from the aggr(sum) function.</P><P>For example: I am trying to calculate if(aggr(sum(sales), customer &gt; 0 and sum(sales, customer &lt;= 0, 'LOST') now here the condition is not getting true since there may be NULL values obtained by the result of this expression. So I would like to replace the null values with zeros so that this condition is always evaluated as true when values are zero or null.</P><P>I hope you got my problem. Please advise the solution asap.</P><P>Thanks and Regards</P><P>Sajid Mahmood</P></BODY></HTML> Fri, 18 Jun 2010 20:26:07 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-Null-value-as-0-in-expression-while-using-sum/m-p/194399#M55313 Sajid_Mahmood 2010-06-18T20:26:07Z How to calculate Null value as 0 in expression while using sum or aggr function https://community.qlik.com/t5/QlikView/How-to-calculate-Null-value-as-0-in-expression-while-using-sum/m-p/194400#M55314 <HTML><HEAD></HEAD><BODY><P>You can use:</P><P>If(isnull(value), 0, value)</P><P>or</P><P>If(isnull(sum(value)), 0, sum(value))</P></BODY></HTML> Fri, 18 Jun 2010 20:36:12 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-Null-value-as-0-in-expression-while-using-sum/m-p/194400#M55314 2010-06-18T20:36:12Z