topic Re: How to Sum less than equal 0 values to show on textbox in QlikView https://community.qlik.com/t5/QlikView/How-to-Sum-less-than-equal-0-values-to-show-on-textbox/m-p/1246489#M857202 <HTML><HEAD></HEAD><BODY><P>Thank&nbsp; you.</P></BODY></HTML> Fri, 27 Jan 2017 11:39:38 GMT ashokpaladugula 2017-01-27T11:39:38Z How to Sum less than equal 0 values to show on textbox https://community.qlik.com/t5/QlikView/How-to-Sum-less-than-equal-0-values-to-show-on-textbox/m-p/1246487#M857200 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I;m unable to sum the negative values.</P><P></P><P>My scenario like this.</P><P>&nbsp;&nbsp; </P><TABLE border="1" class="jiveBorder" height="174" style="border: 1px solid #000000; width: 209px; height: 126px;" width="207"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Delivery Hours</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Shipment Count</TH></TR><TR><TD style="padding: 2px;">-5</TD><TD style="padding: 2px;">100</TD></TR><TR><TD style="padding: 2px;">-4</TD><TD style="padding: 2px;">150</TD></TR><TR><TD style="padding: 2px;">-2</TD><TD style="padding: 2px;">200</TD></TR><TR><TD style="padding: 2px;">0</TD><TD style="padding: 2px;">500</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">300</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">100</TD></TR></TBODY></TABLE><P></P><P>Now i want Sum the less than or equal '0' values in text object.</P><P></P><P>Please help me.</P><P></P><P>Thanks,</P><P>ASHOK</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-Sum-less-than-equal-0-values-to-show-on-textbox/m-p/1246487#M857200 ashokpaladugula 2020-11-25T16:16:04Z Re: How to Sum less than equal 0 values to show on textbox https://community.qlik.com/t5/QlikView/How-to-Sum-less-than-equal-0-values-to-show-on-textbox/m-p/1246488#M857201 <HTML><HEAD></HEAD><BODY><P>=Sum({&lt;DeliveryHours ={"&lt;=0"}&gt;}<SPAN style="font-size: 13.3333px;">ShipmentCount</SPAN>)</P></BODY></HTML> Fri, 27 Jan 2017 11:33:34 GMT https://community.qlik.com/t5/QlikView/How-to-Sum-less-than-equal-0-values-to-show-on-textbox/m-p/1246488#M857201 Kushal_Chawda 2017-01-27T11:33:34Z Re: How to Sum less than equal 0 values to show on textbox https://community.qlik.com/t5/QlikView/How-to-Sum-less-than-equal-0-values-to-show-on-textbox/m-p/1246489#M857202 <HTML><HEAD></HEAD><BODY><P>Thank&nbsp; you.</P></BODY></HTML> Fri, 27 Jan 2017 11:39:38 GMT https://community.qlik.com/t5/QlikView/How-to-Sum-less-than-equal-0-values-to-show-on-textbox/m-p/1246489#M857202 ashokpaladugula 2017-01-27T11:39:38Z