https://community.qlik.com/t5/App-Development/How-to-Omit-Zeros-from-the-Straight-table/m-p/1936449#M77175 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/47473">@micheledenardi</a>&nbsp;,</P> <P>Thank you for your kind and quick support.</P> Fri, 27 May 2022 10:19:06 GMT Ajith_1997 2022-05-27T10:19:06Z https://community.qlik.com/t5/App-Development/How-to-Omit-Zeros-from-the-Straight-table/m-p/1936424#M77169 <P>Hi All,</P> <P>I have attached a straight table, which shows you some total is zeros. I need to omit rows which has a sum of zero.&nbsp;</P> <P>I have taken balance due column as Sum(DocTotalFC)-Sum(PaidFC),&nbsp; I cannot control from load editor because the balance due gets incorrect figures.</P> <P>As of now, Figures are correct. Just only need those rows omitted which has balance due as zero.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="IssueOmit.JPG" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/80452i3EDB01247C0667E6/image-size/medium?v=v2&amp;px=400" role="button" title="IssueOmit.JPG" alt="IssueOmit.JPG" /></span></P> <P> </P> Fri, 27 May 2022 09:44:43 GMT https://community.qlik.com/t5/App-Development/How-to-Omit-Zeros-from-the-Straight-table/m-p/1936424#M77169 muhammedraleen 2022-05-27T09:44:43Z https://community.qlik.com/t5/App-Development/How-to-Omit-Zeros-from-the-Straight-table/m-p/1936443#M77173 <P>Remove "Include zero values" from Add-ons object tab&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="micheledenardi_0-1653646305046.png" style="width: 695px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/80455i80DE9709DD7C33A5/image-dimensions/695x415?v=v2" width="695" height="415" role="button" title="micheledenardi_0-1653646305046.png" alt="micheledenardi_0-1653646305046.png" /></span></P> <P>&nbsp;</P> Fri, 27 May 2022 10:12:05 GMT https://community.qlik.com/t5/App-Development/How-to-Omit-Zeros-from-the-Straight-table/m-p/1936443#M77173 micheledenardi 2022-05-27T10:12:05Z https://community.qlik.com/t5/App-Development/How-to-Omit-Zeros-from-the-Straight-table/m-p/1936449#M77175 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/47473">@micheledenardi</a>&nbsp;,</P> <P>Thank you for your kind and quick support.</P> Fri, 27 May 2022 10:19:06 GMT https://community.qlik.com/t5/App-Development/How-to-Omit-Zeros-from-the-Straight-table/m-p/1936449#M77175 Ajith_1997 2022-05-27T10:19:06Z