topic Re: display null as zero for aggr in QlikView https://community.qlik.com/t5/QlikView/display-null-as-zero-for-aggr/m-p/1171786#M915557 <HTML><HEAD></HEAD><BODY><P>Another option is to use this:</P><P></P><P><STRONG>=Aggr(Only({&lt;[Code Article] = {"=Sum(Stock) = 0"}&gt;} </STRONG><SPAN style="font-size: 13.3333px;"><STRONG>[Code Article]), </STRONG><SPAN style="font-size: 13.3333px;"><STRONG>[Code Article])</STRONG></SPAN></SPAN></P></BODY></HTML> Wed, 18 May 2016 14:58:51 GMT sunny_talwar 2016-05-18T14:58:51Z display null as zero for aggr https://community.qlik.com/t5/QlikView/display-null-as-zero-for-aggr/m-p/1171784#M915555 <HTML><HEAD></HEAD><BODY><P>I have the following expression</P><P></P><P>=if(AGGR(Stock, [Code Article]) = 0, [Code Article])</P><P></P><P></P><P>I need to display code Article for which stock =0 or stock is null, how to correct it ?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/display-null-as-zero-for-aggr/m-p/1171784#M915555 Anonymous 2020-11-25T16:16:04Z Re: display null as zero for aggr https://community.qlik.com/t5/QlikView/display-null-as-zero-for-aggr/m-p/1171785#M915556 <HTML><HEAD></HEAD><BODY><P>You need to use aggregation function to use AGGR</P><P></P><P>aggr(if(sum(Stock) = 0, [Code Article]),[Code Article])</P></BODY></HTML> Wed, 18 May 2016 14:54:43 GMT https://community.qlik.com/t5/QlikView/display-null-as-zero-for-aggr/m-p/1171785#M915556 Kushal_Chawda 2016-05-18T14:54:43Z Re: display null as zero for aggr https://community.qlik.com/t5/QlikView/display-null-as-zero-for-aggr/m-p/1171786#M915557 <HTML><HEAD></HEAD><BODY><P>Another option is to use this:</P><P></P><P><STRONG>=Aggr(Only({&lt;[Code Article] = {"=Sum(Stock) = 0"}&gt;} </STRONG><SPAN style="font-size: 13.3333px;"><STRONG>[Code Article]), </STRONG><SPAN style="font-size: 13.3333px;"><STRONG>[Code Article])</STRONG></SPAN></SPAN></P></BODY></HTML> Wed, 18 May 2016 14:58:51 GMT https://community.qlik.com/t5/QlikView/display-null-as-zero-for-aggr/m-p/1171786#M915557 sunny_talwar 2016-05-18T14:58:51Z