topic Re: Supress zero values but show 0 orders in QlikView https://community.qlik.com/t5/QlikView/Supress-zero-values-but-show-0-orders/m-p/486961#M181907 <HTML><HEAD></HEAD><BODY><P>Try an expression that returns a value &lt;&gt; 0 for those Orders, like</P><P></P><P>count(FreeOrders)</P><P></P><P>or</P><P></P><P>count({&lt;Value = {0}&gt;} Value)</P><P></P><P>Then hide this expression in presentation tab (assuming a straight table chart).</P></BODY></HTML> Thu, 05 Sep 2013 11:43:00 GMT swuehl 2013-09-05T11:43:00Z Supress zero values but show 0 orders https://community.qlik.com/t5/QlikView/Supress-zero-values-but-show-0-orders/m-p/486960#M181906 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>In QlikView I have got a list of all orders of our customers.</P><P>The expression is the sum of the revenue. There are some orders which are free and will get a zero value.</P><P>In this chart I have checked the option 'Supress zero values', but I would like to see these free orders.</P><P>Any options?</P><P></P><P>Kind regards,</P><P>Henco</P></BODY></HTML> Thu, 05 Sep 2013 11:40:02 GMT https://community.qlik.com/t5/QlikView/Supress-zero-values-but-show-0-orders/m-p/486960#M181906 Anonymous 2013-09-05T11:40:02Z Re: Supress zero values but show 0 orders https://community.qlik.com/t5/QlikView/Supress-zero-values-but-show-0-orders/m-p/486961#M181907 <HTML><HEAD></HEAD><BODY><P>Try an expression that returns a value &lt;&gt; 0 for those Orders, like</P><P></P><P>count(FreeOrders)</P><P></P><P>or</P><P></P><P>count({&lt;Value = {0}&gt;} Value)</P><P></P><P>Then hide this expression in presentation tab (assuming a straight table chart).</P></BODY></HTML> Thu, 05 Sep 2013 11:43:00 GMT https://community.qlik.com/t5/QlikView/Supress-zero-values-but-show-0-orders/m-p/486961#M181907 swuehl 2013-09-05T11:43:00Z