topic Re: Best way to populate null as Zero while using Aggr() and count in QlikView https://community.qlik.com/t5/QlikView/Best-way-to-populate-null-as-Zero-while-using-Aggr-and-count/m-p/1320625#M409343 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny and Vishwanath .Both solutions work perfect</P></BODY></HTML> Mon, 17 Jul 2017 15:55:53 GMT chaper 2017-07-17T15:55:53Z Best way to populate null as Zero while using Aggr() and count https://community.qlik.com/t5/QlikView/Best-way-to-populate-null-as-Zero-while-using-Aggr-and-count/m-p/1320622#M409340 <HTML><HEAD></HEAD><BODY><P>I am trying populate (not just show) null values as Zero while using Aggr().Tried if condition but no luck.</P><P></P><P></P><P>aggr((count({&lt;Fiedl1={'2016'}&gt;}Distinct Field2)),Field3)</P><P></P><P></P><P></P><P>Thanks</P></BODY></HTML> Mon, 17 Jul 2017 15:40:47 GMT https://community.qlik.com/t5/QlikView/Best-way-to-populate-null-as-Zero-while-using-Aggr-and-count/m-p/1320622#M409340 chaper 2017-07-17T15:40:47Z Re: Best way to populate null as Zero while using Aggr() and count https://community.qlik.com/t5/QlikView/Best-way-to-populate-null-as-Zero-while-using-Aggr-and-count/m-p/1320623#M409341 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P>Alt(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">aggr((count({&lt;Fiedl1={'2016'}&gt;}Distinct Field2)),Field3), 0)</SPAN></P></BODY></HTML> Mon, 17 Jul 2017 15:50:58 GMT https://community.qlik.com/t5/QlikView/Best-way-to-populate-null-as-Zero-while-using-Aggr-and-count/m-p/1320623#M409341 vishsaggi 2017-07-17T15:50:58Z Re: Best way to populate null as Zero while using Aggr() and count https://community.qlik.com/t5/QlikView/Best-way-to-populate-null-as-Zero-while-using-Aggr-and-count/m-p/1320624#M409342 <HTML><HEAD></HEAD><BODY><P>Or just this</P><P></P><P><STRONG>Sum(A</STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>ggr((Count({&lt;Fiedl1={'2016'}&gt;}Distinct Field2)), Field3))</STRONG></SPAN></P></BODY></HTML> Mon, 17 Jul 2017 15:51:51 GMT https://community.qlik.com/t5/QlikView/Best-way-to-populate-null-as-Zero-while-using-Aggr-and-count/m-p/1320624#M409342 sunny_talwar 2017-07-17T15:51:51Z Re: Best way to populate null as Zero while using Aggr() and count https://community.qlik.com/t5/QlikView/Best-way-to-populate-null-as-Zero-while-using-Aggr-and-count/m-p/1320625#M409343 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny and Vishwanath .Both solutions work perfect</P></BODY></HTML> Mon, 17 Jul 2017 15:55:53 GMT https://community.qlik.com/t5/QlikView/Best-way-to-populate-null-as-Zero-while-using-Aggr-and-count/m-p/1320625#M409343 chaper 2017-07-17T15:55:53Z Re: Best way to populate null as Zero while using Aggr() and count https://community.qlik.com/t5/QlikView/Best-way-to-populate-null-as-Zero-while-using-Aggr-and-count/m-p/1320626#M409344 <HTML><HEAD></HEAD><BODY><P>Your solution works perfect but Totals not populating.</P></BODY></HTML> Mon, 17 Jul 2017 15:58:53 GMT https://community.qlik.com/t5/QlikView/Best-way-to-populate-null-as-Zero-while-using-Aggr-and-count/m-p/1320626#M409344 chaper 2017-07-17T15:58:53Z Re: Best way to populate null as Zero while using Aggr() and count https://community.qlik.com/t5/QlikView/Best-way-to-populate-null-as-Zero-while-using-Aggr-and-count/m-p/1320627#M409345 <HTML><HEAD></HEAD><BODY><P>Sunny your solution works and also shows right totals on top.Thanks</P></BODY></HTML> Mon, 17 Jul 2017 15:59:38 GMT https://community.qlik.com/t5/QlikView/Best-way-to-populate-null-as-Zero-while-using-Aggr-and-count/m-p/1320627#M409345 chaper 2017-07-17T15:59:38Z