topic Re: remove negative value in QlikView https://community.qlik.com/t5/QlikView/remove-negative-value/m-p/16519#M782907 <HTML><HEAD></HEAD><BODY><P>May be this expression</P><P></P><P><STRONG>=Sum({&lt;Item = {"=Sum(Quantity)&gt;0"}&gt;}<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Quantity</SPAN>)</STRONG></P></BODY></HTML> Tue, 27 Mar 2018 10:29:49 GMT shiveshsingh 2018-03-27T10:29:49Z remove negative value https://community.qlik.com/t5/QlikView/remove-negative-value/m-p/16517#M782905 <HTML><HEAD></HEAD><BODY><P>Hello There,</P><P>&nbsp; My concern is so so simple but i don't know how to do that regarding the negative value, i want to remove.</P><P></P><P>Sample:</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Item&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Quantity</P><P>&nbsp;&nbsp;&nbsp;&nbsp; motorcycle&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>&nbsp;&nbsp;&nbsp;&nbsp; car&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -1</P><P></P><P>how can i remove/skip THE negative value at the list?</P><P>be like below:this is what i want to display.</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Item&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Quantity</P><P>&nbsp;&nbsp;&nbsp;&nbsp; motorcycle&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P></P><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/m-p/16517#M782905 bsbernabe 2020-11-25T16:16:04Z Re: remove negative value https://community.qlik.com/t5/QlikView/remove-negative-value/m-p/16518#M782906 <HTML><HEAD></HEAD><BODY><P>Use something like below</P><P></P><P>IF(SUM(Quantity)&gt;0,SUM(Quantity))</P><P>or</P><P>SUM({&lt;Item = {"=SUM(Quantity)&gt;0"}&gt;}Quantity)</P></BODY></HTML> Tue, 27 Mar 2018 09:34:52 GMT https://community.qlik.com/t5/QlikView/remove-negative-value/m-p/16518#M782906 MK_QSL 2018-03-27T09:34:52Z Re: remove negative value https://community.qlik.com/t5/QlikView/remove-negative-value/m-p/16519#M782907 <HTML><HEAD></HEAD><BODY><P>May be this expression</P><P></P><P><STRONG>=Sum({&lt;Item = {"=Sum(Quantity)&gt;0"}&gt;}<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Quantity</SPAN>)</STRONG></P></BODY></HTML> Tue, 27 Mar 2018 10:29:49 GMT https://community.qlik.com/t5/QlikView/remove-negative-value/m-p/16519#M782907 shiveshsingh 2018-03-27T10:29:49Z