https://community.qlik.com/t5/App-Development/Pie-Chart-only-negative-or-zero-values/m-p/2511754#M105117 <P>What is a good way to troubleshoot this error message on a pie chart?&nbsp;</P><P>I am trying to divide up the total value of inventory by it's type, and yes some have zero dollars on hand but there are no negative values.&nbsp;</P><P>How can I get this pie chart working?</P> Wed, 26 Mar 2025 22:56:16 GMT jalanhart 2025-03-26T22:56:16Z https://community.qlik.com/t5/App-Development/Pie-Chart-only-negative-or-zero-values/m-p/2511754#M105117 <P>What is a good way to troubleshoot this error message on a pie chart?&nbsp;</P><P>I am trying to divide up the total value of inventory by it's type, and yes some have zero dollars on hand but there are no negative values.&nbsp;</P><P>How can I get this pie chart working?</P> Wed, 26 Mar 2025 22:56:16 GMT https://community.qlik.com/t5/App-Development/Pie-Chart-only-negative-or-zero-values/m-p/2511754#M105117 jalanhart 2025-03-26T22:56:16Z https://community.qlik.com/t5/App-Development/Pie-Chart-only-negative-or-zero-values/m-p/2511766#M105118 <P>Try this&nbsp;</P><P>IF(Sum(InventoryValue) &gt; 0, Sum(InventoryValue))</P><P>Or&nbsp;</P><P>Sum({&lt;InventoryValue={"&gt;0"}&gt;} InventoryValue)</P><P>&nbsp;</P> Thu, 27 Mar 2025 04:04:53 GMT https://community.qlik.com/t5/App-Development/Pie-Chart-only-negative-or-zero-values/m-p/2511766#M105118 Chanty4u 2025-03-27T04:04:53Z https://community.qlik.com/t5/App-Development/Pie-Chart-only-negative-or-zero-values/m-p/2511780#M105124 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/244105">@jalanhart</a>&nbsp;Try rangesum</P> Thu, 27 Mar 2025 05:50:22 GMT https://community.qlik.com/t5/App-Development/Pie-Chart-only-negative-or-zero-values/m-p/2511780#M105124 Bhushan_Mahajan 2025-03-27T05:50:22Z