topic Re: Remove -0 Value from data in QlikView https://community.qlik.com/t5/QlikView/Remove-0-Value-from-data/m-p/1427202#M429718 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><STRONG>Num(Round(A-B), '#')</STRONG></P></BODY></HTML> Fri, 18 Aug 2017 13:19:01 GMT sunny_talwar 2017-08-18T13:19:01Z Remove -0 Value from data https://community.qlik.com/t5/QlikView/Remove-0-Value-from-data/m-p/1427201#M429717 <HTML><HEAD></HEAD><BODY><P>Hi Team,</P><P></P><P>I have two below tables and when I am doing A-B, it is giving the below result:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">A</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">B</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">A-B</TH></TR><TR><TD style="padding: 2px;">8.74</TD><TD style="padding: 2px;">8.76</TD><TD style="padding: 2px;">-0.02</TD></TR><TR><TD style="padding: 2px;">8.76</TD><TD style="padding: 2px;">9.74</TD><TD style="padding: 2px;">-0.98</TD></TR></TBODY></TABLE><P></P><P>But When I am changing Number format for (A-B) as integer it is giving below result:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">A</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">B</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">A-B</TH></TR><TR><TD style="padding: 2px;">8.74</TD><TD style="padding: 2px;">8.76</TD><TD style="padding: 2px;">-0</TD></TR><TR><TD style="padding: 2px;">8.76</TD><TD style="padding: 2px;">9.74</TD><TD style="padding: 2px;">-1</TD></TR></TBODY></TABLE><P></P><P>So here it is giving value as -0. I want to remove this negative sign from zero(0) as there is no mean of -0.</P><P></P><P>Can anybody help me?</P></BODY></HTML> Fri, 18 Aug 2017 13:18:04 GMT https://community.qlik.com/t5/QlikView/Remove-0-Value-from-data/m-p/1427201#M429717 vipingarg23 2017-08-18T13:18:04Z Re: Remove -0 Value from data https://community.qlik.com/t5/QlikView/Remove-0-Value-from-data/m-p/1427202#M429718 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><STRONG>Num(Round(A-B), '#')</STRONG></P></BODY></HTML> Fri, 18 Aug 2017 13:19:01 GMT https://community.qlik.com/t5/QlikView/Remove-0-Value-from-data/m-p/1427202#M429718 sunny_talwar 2017-08-18T13:19:01Z Re: Remove -0 Value from data https://community.qlik.com/t5/QlikView/Remove-0-Value-from-data/m-p/1427203#M429719 <HTML><HEAD></HEAD><BODY><P>Very quick and brilliant answer. It is working fine. Thanks a ton...</P></BODY></HTML> Fri, 18 Aug 2017 13:24:03 GMT https://community.qlik.com/t5/QlikView/Remove-0-Value-from-data/m-p/1427203#M429719 vipingarg23 2017-08-18T13:24:03Z Re: Remove -0 Value from data https://community.qlik.com/t5/QlikView/Remove-0-Value-from-data/m-p/1427204#M429720 <HTML><HEAD></HEAD><BODY><P>And yet you did not mark my response as correct <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />...</P><P></P><P>Anyways, I am glad it worked...</P></BODY></HTML> Fri, 18 Aug 2017 13:24:55 GMT https://community.qlik.com/t5/QlikView/Remove-0-Value-from-data/m-p/1427204#M429720 sunny_talwar 2017-08-18T13:24:55Z Re: Remove -0 Value from data https://community.qlik.com/t5/QlikView/Remove-0-Value-from-data/m-p/1427205#M429721 <HTML><HEAD></HEAD><BODY><P>I have marked as correct...Thanks</P></BODY></HTML> Fri, 18 Aug 2017 13:33:55 GMT https://community.qlik.com/t5/QlikView/Remove-0-Value-from-data/m-p/1427205#M429721 vipingarg23 2017-08-18T13:33:55Z