topic Re: How to remove or hide 0% values from an expression in straight table in QlikView https://community.qlik.com/t5/QlikView/How-to-remove-or-hide-0-values-from-an-expression-in-straight/m-p/581287#M1096964 <HTML><HEAD></HEAD><BODY><P>use <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">suppress when value zero</SPAN> otherwsie in expression change like</P><P></P><P>Ex:-</P><P>=If(&nbsp; Sum(Yourexpression) &gt;0, Sum(Yourexpression)) </P><P></P><P>This will avoid the 0% from the expression</P></BODY></HTML> Wed, 30 Apr 2014 11:24:37 GMT its_anandrjs 2014-04-30T11:24:37Z How to remove or hide 0% values from an expression in straight table https://community.qlik.com/t5/QlikView/How-to-remove-or-hide-0-values-from-an-expression-in-straight/m-p/581286#M1096963 <HTML><HEAD></HEAD><BODY><P>HI,</P><P></P><P>In my straight table chart i am getting 0% values in a chart i need to avoid those. I am not able to to that by checking property suppress zero value in presentation tab. What is the way to avoid those?</P></BODY></HTML> Wed, 30 Apr 2014 11:21:34 GMT https://community.qlik.com/t5/QlikView/How-to-remove-or-hide-0-values-from-an-expression-in-straight/m-p/581286#M1096963 rsdhavle 2014-04-30T11:21:34Z Re: How to remove or hide 0% values from an expression in straight table https://community.qlik.com/t5/QlikView/How-to-remove-or-hide-0-values-from-an-expression-in-straight/m-p/581287#M1096964 <HTML><HEAD></HEAD><BODY><P>use <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">suppress when value zero</SPAN> otherwsie in expression change like</P><P></P><P>Ex:-</P><P>=If(&nbsp; Sum(Yourexpression) &gt;0, Sum(Yourexpression)) </P><P></P><P>This will avoid the 0% from the expression</P></BODY></HTML> Wed, 30 Apr 2014 11:24:37 GMT https://community.qlik.com/t5/QlikView/How-to-remove-or-hide-0-values-from-an-expression-in-straight/m-p/581287#M1096964 its_anandrjs 2014-04-30T11:24:37Z Re: How to remove or hide 0% values from an expression in straight table https://community.qlik.com/t5/QlikView/How-to-remove-or-hide-0-values-from-an-expression-in-straight/m-p/581288#M1096965 <HTML><HEAD></HEAD><BODY><P>It may be possible that the actual value are 0.0024% or something like this.</P><P>If it is exactly 0%, suppress zero values should remove them.</P><P>Check by going to number tab and Fixed to 3 or 4 decimals..</P></BODY></HTML> Wed, 30 Apr 2014 11:25:49 GMT https://community.qlik.com/t5/QlikView/How-to-remove-or-hide-0-values-from-an-expression-in-straight/m-p/581288#M1096965 MK_QSL 2014-04-30T11:25:49Z