topic Re: How to hide rows with 0 in expression in App Development https://community.qlik.com/t5/App-Development/How-to-hide-rows-with-0-in-expression/m-p/649466#M9964 <HTML><HEAD></HEAD><BODY><P>Can use below expression instead? </P><P></P><P>IF (sum(SALES)=0,'',OrderID)</P><P></P><P>I try but not working..</P></BODY></HTML> Wed, 07 Jan 2015 06:13:47 GMT 2015-01-07T06:13:47Z How to hide rows with 0 in expression https://community.qlik.com/t5/App-Development/How-to-hide-rows-with-0-in-expression/m-p/649463#M9961 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>I just started using Qlik Sense after working with Qlikview for over 7 years.</P><P></P><P>I was wondering if it's possible to only show lines that have a non-null value in expression for a table (Similar to <STRONG>Presentation - Suppress Zero Values </STRONG>in Qlikview).</P><P></P><P>Thanks in advance,</P><P>Alecs</P></BODY></HTML> Fri, 17 Oct 2014 10:03:04 GMT https://community.qlik.com/t5/App-Development/How-to-hide-rows-with-0-in-expression/m-p/649463#M9961 galrion82 2014-10-17T10:03:04Z Re: How to hide rows with 0 in expression https://community.qlik.com/t5/App-Development/How-to-hide-rows-with-0-in-expression/m-p/649464#M9962 <HTML><HEAD></HEAD><BODY><P>The setting is not there so it makes conditional null approach to filtering expressions&nbsp; (IE:&nbsp;&nbsp; IF( condition, value)&nbsp;&nbsp; )&nbsp; not permissible in exactly the same way.</P><P></P><P>I was able to replicate the effect using the condition on the dimension , because there is a 'show nulls' checkbox there. (see below)</P><P></P><P>Other ways to filter out NULLs in the expression like&nbsp; set analysis will work too. </P><P></P><P>If there is a very specific technique or approach you are asking about...please post.</P><P></P><P><IMG alt="Untitled.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/69199_Untitled.png" style="width: 620px; height: 359px;" /></P></BODY></HTML> Fri, 17 Oct 2014 17:19:20 GMT https://community.qlik.com/t5/App-Development/How-to-hide-rows-with-0-in-expression/m-p/649464#M9962 JonnyPoole 2014-10-17T17:19:20Z Re: How to hide rows with 0 in expression https://community.qlik.com/t5/App-Development/How-to-hide-rows-with-0-in-expression/m-p/649465#M9963 <HTML><HEAD></HEAD><BODY><P>Did yoh get an answer to your question? </P></BODY></HTML> Tue, 28 Oct 2014 00:39:52 GMT https://community.qlik.com/t5/App-Development/How-to-hide-rows-with-0-in-expression/m-p/649465#M9963 JonnyPoole 2014-10-28T00:39:52Z Re: How to hide rows with 0 in expression https://community.qlik.com/t5/App-Development/How-to-hide-rows-with-0-in-expression/m-p/649466#M9964 <HTML><HEAD></HEAD><BODY><P>Can use below expression instead? </P><P></P><P>IF (sum(SALES)=0,'',OrderID)</P><P></P><P>I try but not working..</P></BODY></HTML> Wed, 07 Jan 2015 06:13:47 GMT https://community.qlik.com/t5/App-Development/How-to-hide-rows-with-0-in-expression/m-p/649466#M9964 2015-01-07T06:13:47Z