https://community.qlik.com/t5/QlikView/Hide-rows-based-on-null-or-zero-values-in-the-measure/m-p/1562582#M441406 <P>Hi, If a cell has a value for a row that row will be shown.</P><P>You can check each dimension like "=If(not IsNull([Check]), count(Package))"</P><P>Or do a calculated dimension like "=aggr(if(Count([Order Number])+Count(Package)&lt;2, [Part Number]), [Part Number])"</P> Thu, 28 Mar 2019 18:07:28 GMT rubenmarin 2019-03-28T18:07:28Z https://community.qlik.com/t5/QlikView/Hide-rows-based-on-null-or-zero-values-in-the-measure/m-p/1562486#M441399 <P>Hi,&nbsp;</P><P>I am trying to hide rows where measure values are zero or null.&nbsp; This works well if i have only one measure.&nbsp;</P><P><FONT color="#FF0000"><STRONG>How do i make it work when i have more than one measure ?</STRONG></FONT></P><P>I have attached a test case qvw file for reference.</P><P>I have want to hide rows where check column in null</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 863px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/9038i2498DBE737B463E1/image-size/large?v=v2&amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P><P>Thanks,</P><P>Vidya</P> Thu, 28 Mar 2019 14:18:53 GMT https://community.qlik.com/t5/QlikView/Hide-rows-based-on-null-or-zero-values-in-the-measure/m-p/1562486#M441399 poluvidyasagar 2019-03-28T14:18:53Z https://community.qlik.com/t5/QlikView/Hide-rows-based-on-null-or-zero-values-in-the-measure/m-p/1562582#M441406 <P>Hi, If a cell has a value for a row that row will be shown.</P><P>You can check each dimension like "=If(not IsNull([Check]), count(Package))"</P><P>Or do a calculated dimension like "=aggr(if(Count([Order Number])+Count(Package)&lt;2, [Part Number]), [Part Number])"</P> Thu, 28 Mar 2019 18:07:28 GMT https://community.qlik.com/t5/QlikView/Hide-rows-based-on-null-or-zero-values-in-the-measure/m-p/1562582#M441406 rubenmarin 2019-03-28T18:07:28Z