topic Sum A Value Based On Null In Another Column in QlikView https://community.qlik.com/t5/QlikView/Sum-A-Value-Based-On-Null-In-Another-Column/m-p/299925#M111089 <HTML><HEAD></HEAD><BODY><P> Thanks for the help it worked perfectly</P></BODY></HTML> Fri, 26 Aug 2011 16:32:22 GMT 2011-08-26T16:32:22Z Sum A Value Based On Null In Another Column https://community.qlik.com/t5/QlikView/Sum-A-Value-Based-On-Null-In-Another-Column/m-p/299923#M111087 <HTML><HEAD></HEAD><BODY><P>Within a chart I need to sum the hours taken to do a job, DmBAA.REGHOURS, when a certain column in the data , DmBAA.EQUIPNUM, has a null value. I've tried if (IsNull(DmBAA.EQUIPNUM), Sum(DmBAA.REGHOURS)) but it sums all the values rather than just the null ones. Can any one help?</P></BODY></HTML> Thu, 25 Aug 2011 10:10:05 GMT https://community.qlik.com/t5/QlikView/Sum-A-Value-Based-On-Null-In-Another-Column/m-p/299923#M111087 2011-08-25T10:10:05Z Sum A Value Based On Null In Another Column https://community.qlik.com/t5/QlikView/Sum-A-Value-Based-On-Null-In-Another-Column/m-p/299924#M111088 <HTML><HEAD></HEAD><BODY><P>Not sure, if this is correct, because I don't know your dimensions, data model etc, but I would try:</P><P>=sum(if(isNull(DmBAA.EQUIPNUM)=-1,DmBAA.REGHOURS))</P><P></P><P>i.e. putting the if() inside the sum to limit the rows to sum.</P><P></P><P>Regards,</P><P>Stefan</P></BODY></HTML> Thu, 25 Aug 2011 11:05:34 GMT https://community.qlik.com/t5/QlikView/Sum-A-Value-Based-On-Null-In-Another-Column/m-p/299924#M111088 swuehl 2011-08-25T11:05:34Z Sum A Value Based On Null In Another Column https://community.qlik.com/t5/QlikView/Sum-A-Value-Based-On-Null-In-Another-Column/m-p/299925#M111089 <HTML><HEAD></HEAD><BODY><P> Thanks for the help it worked perfectly</P></BODY></HTML> Fri, 26 Aug 2011 16:32:22 GMT https://community.qlik.com/t5/QlikView/Sum-A-Value-Based-On-Null-In-Another-Column/m-p/299925#M111089 2011-08-26T16:32:22Z