topic Pain in the *** Nulls in QlikView https://community.qlik.com/t5/QlikView/Pain-in-the-Nulls/m-p/172696#M42158 <HTML><HEAD></HEAD><BODY><P>Well, that's a little better. I still wish there were a global setting that could be set in the script.</P></BODY></HTML> Tue, 22 Mar 2011 00:44:48 GMT Anonymous 2011-03-22T00:44:48Z Pain in the *** Nulls https://community.qlik.com/t5/QlikView/Pain-in-the-Nulls/m-p/172694#M42156 <HTML><HEAD></HEAD><BODY><P>Is there an easier way, a global way possibly, to deal with Nulls so that I don't have to keep turning expression like this:</P><P>Column(3)-Column(1)+Column(2)</P><P>into expressions like this:</P><P>if(isnull(Column(3)),0,Column(3))-if(isnull(Column(1)),0,Column(1))+if(isnull(Column(2)),0,Column(2))</P><P></P></BODY></HTML> Mon, 21 Mar 2011 22:31:03 GMT https://community.qlik.com/t5/QlikView/Pain-in-the-Nulls/m-p/172694#M42156 Anonymous 2011-03-21T22:31:03Z Pain in the *** Nulls https://community.qlik.com/t5/QlikView/Pain-in-the-Nulls/m-p/172695#M42157 <HTML><HEAD></HEAD><BODY><P>RANGESUM(Column(1), Column(2), Column(3)) - that's exactly what it does.</P></BODY></HTML> Mon, 21 Mar 2011 22:39:58 GMT https://community.qlik.com/t5/QlikView/Pain-in-the-Nulls/m-p/172695#M42157 Oleg_Troyansky 2011-03-21T22:39:58Z Pain in the *** Nulls https://community.qlik.com/t5/QlikView/Pain-in-the-Nulls/m-p/172696#M42158 <HTML><HEAD></HEAD><BODY><P>Well, that's a little better. I still wish there were a global setting that could be set in the script.</P></BODY></HTML> Tue, 22 Mar 2011 00:44:48 GMT https://community.qlik.com/t5/QlikView/Pain-in-the-Nulls/m-p/172696#M42158 Anonymous 2011-03-22T00:44:48Z