topic Re: Remove NULLs from the report in QlikView https://community.qlik.com/t5/QlikView/Remove-NULLs-from-the-report/m-p/515171#M1130605 <HTML><HEAD></HEAD><BODY><P>In that case it shows 0 or the sum.</P></BODY></HTML> Tue, 12 Nov 2013 21:57:58 GMT 2013-11-12T21:57:58Z Remove NULLs from the report https://community.qlik.com/t5/QlikView/Remove-NULLs-from-the-report/m-p/515169#M1130603 <HTML><HEAD></HEAD><BODY><P>There is straight table (detail report) and it has few derived columns through expression. Sometimes the expression output is NULL (expected).</P><P>We don't want those rows to be displayed in the report. How to suppress the NULL values in the report.</P></BODY></HTML> Tue, 12 Nov 2013 21:45:24 GMT https://community.qlik.com/t5/QlikView/Remove-NULLs-from-the-report/m-p/515169#M1130603 2013-11-12T21:45:24Z Re: Remove NULLs from the report https://community.qlik.com/t5/QlikView/Remove-NULLs-from-the-report/m-p/515170#M1130604 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>you may need to change the expressions to only show values greater than 0</P><P></P><P>something like</P><P></P><P>IF(Sum(Sales) &gt; 0,0,Sum(Sales))</P></BODY></HTML> Tue, 12 Nov 2013 21:55:17 GMT https://community.qlik.com/t5/QlikView/Remove-NULLs-from-the-report/m-p/515170#M1130604 rustyfishbones 2013-11-12T21:55:17Z Re: Remove NULLs from the report https://community.qlik.com/t5/QlikView/Remove-NULLs-from-the-report/m-p/515171#M1130605 <HTML><HEAD></HEAD><BODY><P>In that case it shows 0 or the sum.</P></BODY></HTML> Tue, 12 Nov 2013 21:57:58 GMT https://community.qlik.com/t5/QlikView/Remove-NULLs-from-the-report/m-p/515171#M1130605 2013-11-12T21:57:58Z Re: Remove NULLs from the report https://community.qlik.com/t5/QlikView/Remove-NULLs-from-the-report/m-p/515172#M1130606 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can try checking "Suppress When Value is Null" on the Dimension Tab.</P><P></P><P><IMG alt="null.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/48879_null.png" style="width: 620px; height: 506px;" /></P><P></P><P></P><P><SPAN class="Bold">Suppress When Value Is NULL</SPAN> </P><P>If this check box is enabled, the selected dimension in the <SPAN class="Bold">Used Dimensions</SPAN> above will not be displayed in the chart if its value is NULL.</P><P></P><P><BR />Bill</P></BODY></HTML> Tue, 12 Nov 2013 22:01:48 GMT https://community.qlik.com/t5/QlikView/Remove-NULLs-from-the-report/m-p/515172#M1130606 Bill_Britt 2013-11-12T22:01:48Z Re: Remove NULLs from the report https://community.qlik.com/t5/QlikView/Remove-NULLs-from-the-report/m-p/515173#M1130607 <HTML><HEAD></HEAD><BODY><P>Sorry, you are correct</P><P></P><P>Sum(Sales) &gt; 0</P></BODY></HTML> Tue, 12 Nov 2013 22:02:17 GMT https://community.qlik.com/t5/QlikView/Remove-NULLs-from-the-report/m-p/515173#M1130607 rustyfishbones 2013-11-12T22:02:17Z