topic How to subtract missing values in QlikView https://community.qlik.com/t5/QlikView/How-to-subtract-missing-values/m-p/689895#M249777 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>In a staright table I am trying to subtract ' a missing value like</P><P></P><P>'-' - 800 its showing as zero instead of -800.</P><P></P><P>I want to subtract the missing values consedering them as zeros in a straight table.</P><P></P><P>Thanks</P></BODY></HTML> Tue, 02 Sep 2014 11:52:29 GMT 2014-09-02T11:52:29Z How to subtract missing values https://community.qlik.com/t5/QlikView/How-to-subtract-missing-values/m-p/689895#M249777 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>In a staright table I am trying to subtract ' a missing value like</P><P></P><P>'-' - 800 its showing as zero instead of -800.</P><P></P><P>I want to subtract the missing values consedering them as zeros in a straight table.</P><P></P><P>Thanks</P></BODY></HTML> Tue, 02 Sep 2014 11:52:29 GMT https://community.qlik.com/t5/QlikView/How-to-subtract-missing-values/m-p/689895#M249777 2014-09-02T11:52:29Z Re: How to subtract missing values https://community.qlik.com/t5/QlikView/How-to-subtract-missing-values/m-p/689896#M249778 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You need to replace null value with zero.</P><P></P><P>have a look at attached document.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Tue, 02 Sep 2014 11:55:18 GMT https://community.qlik.com/t5/QlikView/How-to-subtract-missing-values/m-p/689896#M249778 ashfaq_haseeb 2014-09-02T11:55:18Z Re: How to subtract missing values https://community.qlik.com/t5/QlikView/How-to-subtract-missing-values/m-p/689897#M249779 <HTML><HEAD></HEAD><BODY><P>=IF(Len(Trim(Replace(YourFieldName,'-','')))=0 or ISNULL(YourFieldName),0)-800</P></BODY></HTML> Tue, 02 Sep 2014 11:59:53 GMT https://community.qlik.com/t5/QlikView/How-to-subtract-missing-values/m-p/689897#M249779 MK_QSL 2014-09-02T11:59:53Z