topic Remove negative value using expression in QlikView https://community.qlik.com/t5/QlikView/Remove-negative-value-using-expression/m-p/26482#M776753 <HTML><HEAD></HEAD><BODY><P>Hello There,</P><P></P><P>In expression how to create to remove all negative value in 1 field is there a way about it?</P><P></P><TABLE border="1" class="jiveBorder" height="50" style="border: 1px solid rgb(0, 0, 0); width: 303px; height: 8px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Internal ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Item</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Quantity</STRONG></TH></TR><TR><TD style="padding: 2px;">368443</TD><TD style="padding: 2px;">U100805</TD><TD style="padding: 2px;">-1</TD></TR><TR><TD style="padding: 2px;">9888</TD><TD style="padding: 2px;">U100456</TD><TD style="padding: 2px;">1</TD></TR></TBODY></TABLE><P></P><P>Best Regards,</P><P>Bing</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT bsbernabe 2020-11-25T16:16:04Z Remove negative value using expression https://community.qlik.com/t5/QlikView/Remove-negative-value-using-expression/m-p/26482#M776753 <HTML><HEAD></HEAD><BODY><P>Hello There,</P><P></P><P>In expression how to create to remove all negative value in 1 field is there a way about it?</P><P></P><TABLE border="1" class="jiveBorder" height="50" style="border: 1px solid rgb(0, 0, 0); width: 303px; height: 8px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Internal ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Item</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Quantity</STRONG></TH></TR><TR><TD style="padding: 2px;">368443</TD><TD style="padding: 2px;">U100805</TD><TD style="padding: 2px;">-1</TD></TR><TR><TD style="padding: 2px;">9888</TD><TD style="padding: 2px;">U100456</TD><TD style="padding: 2px;">1</TD></TR></TBODY></TABLE><P></P><P>Best Regards,</P><P>Bing</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Remove-negative-value-using-expression/m-p/26482#M776753 bsbernabe 2020-11-25T16:16:04Z Re: Remove negative value using expression https://community.qlik.com/t5/QlikView/Remove-negative-value-using-expression/m-p/26483#M776754 <HTML><HEAD></HEAD><BODY><P>May be using an if statement?</P><P></P><P><STRONG>If(Quantity &lt; 0, Null(), Quantity)</STRONG></P></BODY></HTML> Fri, 27 Apr 2018 01:48:11 GMT https://community.qlik.com/t5/QlikView/Remove-negative-value-using-expression/m-p/26483#M776754 sunny_talwar 2018-04-27T01:48:11Z