topic How to suppress row when Total column = zero value for Aging Table in App Development https://community.qlik.com/t5/App-Development/How-to-suppress-row-when-Total-column-zero-value-for-Aging-Table/m-p/1228081#M23947 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P></P><P>How to suppress row when Total column = zero value.</P><P></P><P></P><P>I have already try to check at dimension tab and presentation tab. but still cannot hide.</P><P></P><P></P><P>Paul</P></BODY></HTML> Fri, 23 Dec 2016 02:07:41 GMT paulyeo11 2016-12-23T02:07:41Z How to suppress row when Total column = zero value for Aging Table https://community.qlik.com/t5/App-Development/How-to-suppress-row-when-Total-column-zero-value-for-Aging-Table/m-p/1228081#M23947 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P></P><P>How to suppress row when Total column = zero value.</P><P></P><P></P><P>I have already try to check at dimension tab and presentation tab. but still cannot hide.</P><P></P><P></P><P>Paul</P></BODY></HTML> Fri, 23 Dec 2016 02:07:41 GMT https://community.qlik.com/t5/App-Development/How-to-suppress-row-when-Total-column-zero-value-for-Aging-Table/m-p/1228081#M23947 paulyeo11 2016-12-23T02:07:41Z Re: How to suppress row when Total column = zero value for Aging Table https://community.qlik.com/t5/App-Development/How-to-suppress-row-when-Total-column-zero-value-for-Aging-Table/m-p/1228082#M23948 <HTML><HEAD></HEAD><BODY><P>my qvw</P></BODY></HTML> Fri, 23 Dec 2016 02:09:00 GMT https://community.qlik.com/t5/App-Development/How-to-suppress-row-when-Total-column-zero-value-for-Aging-Table/m-p/1228082#M23948 paulyeo11 2016-12-23T02:09:00Z Re: How to suppress row when Total column = zero value for Aging Table https://community.qlik.com/t5/App-Development/How-to-suppress-row-when-Total-column-zero-value-for-Aging-Table/m-p/1228083#M23949 <HTML><HEAD></HEAD><BODY><P>May be use this expression:</P><P></P><P><STRONG>If(Sum(TOTAL &lt;COMPANY_PAY&gt; total_ar) &gt; 0, Sum(total_ar))</STRONG></P><P></P><P><IMG __jive_id="147490" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/147490_Capture.PNG" style="height: 179px; width: 620px;" /></P></BODY></HTML> Fri, 23 Dec 2016 02:42:28 GMT https://community.qlik.com/t5/App-Development/How-to-suppress-row-when-Total-column-zero-value-for-Aging-Table/m-p/1228083#M23949 sunny_talwar 2016-12-23T02:42:28Z Re: How to suppress row when Total column = zero value for Aging Table https://community.qlik.com/t5/App-Development/How-to-suppress-row-when-Total-column-zero-value-for-Aging-Table/m-p/1228084#M23950 <HTML><HEAD></HEAD><BODY><P>Hi Sunny</P><P></P><P>Thank you very much . it work.,</P><P></P><P>Paul</P></BODY></HTML> Fri, 23 Dec 2016 03:38:48 GMT https://community.qlik.com/t5/App-Development/How-to-suppress-row-when-Total-column-zero-value-for-Aging-Table/m-p/1228084#M23950 paulyeo11 2016-12-23T03:38:48Z