topic Re: how to remove rows in QlikView https://community.qlik.com/t5/QlikView/how-to-remove-rows/m-p/89083#M14535 <HTML><HEAD></HEAD><BODY><P>May be use Where function</P><P></P><P><STRONG>LOAD ...</STRONG></P><P><STRONG>FROM ..</STRONG></P><P><STRONG>Where Len(Trim(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">product</SPAN>)) &gt; 0;</STRONG></P></BODY></HTML> Tue, 31 Jul 2018 15:16:58 GMT sunny_talwar 2018-07-31T15:16:58Z how to remove rows https://community.qlik.com/t5/QlikView/how-to-remove-rows/m-p/89082#M14534 <HTML><HEAD></HEAD><BODY><P>Hi all i have a field name product</P><P>data like </P><P>-</P><P>baby</P><P>200</P><P>350</P><P>-</P><P>-</P><P>-</P><P>how to remove empty rows </P></BODY></HTML> Tue, 31 Jul 2018 13:04:13 GMT https://community.qlik.com/t5/QlikView/how-to-remove-rows/m-p/89082#M14534 Anonymous 2018-07-31T13:04:13Z Re: how to remove rows https://community.qlik.com/t5/QlikView/how-to-remove-rows/m-p/89083#M14535 <HTML><HEAD></HEAD><BODY><P>May be use Where function</P><P></P><P><STRONG>LOAD ...</STRONG></P><P><STRONG>FROM ..</STRONG></P><P><STRONG>Where Len(Trim(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">product</SPAN>)) &gt; 0;</STRONG></P></BODY></HTML> Tue, 31 Jul 2018 15:16:58 GMT https://community.qlik.com/t5/QlikView/how-to-remove-rows/m-p/89083#M14535 sunny_talwar 2018-07-31T15:16:58Z Re: how to remove rows https://community.qlik.com/t5/QlikView/how-to-remove-rows/m-p/89084#M14536 <HTML><HEAD></HEAD><BODY><P>Product:</P><P>Load</P><P>ProductID,</P><P>Len(Trim(Product)) &gt; 0 as Product,</P><P>ProductGroup</P><P>from Product</P><P>group by ProductID;</P><P></P><P>Or</P><P></P><P>Product:</P><P>Load</P><P>Product,</P><P>ProductGroup</P><P>From Product where Len(Trim(Product)) &gt; 0;</P></BODY></HTML> Tue, 31 Jul 2018 16:09:12 GMT https://community.qlik.com/t5/QlikView/how-to-remove-rows/m-p/89084#M14536 BalaBhaskar_Qlik 2018-07-31T16:09:12Z