topic Help.. in QlikView https://community.qlik.com/t5/QlikView/Help/m-p/478075#M1122380 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P><STRONG>Type</STRONG></P><P>A00E</P><P>A001</P><P>A009</P><P>M00E</P><P>K009</P><P>M09E</P><P></P><P><STRONG>How to exclude ending with E</STRONG><BR />O/p would be</P><P><STRONG>Type</STRONG></P><P>A001</P><P>A009</P><P>K009</P></BODY></HTML> Tue, 07 Jan 2014 16:22:51 GMT paulwalker 2014-01-07T16:22:51Z Help.. https://community.qlik.com/t5/QlikView/Help/m-p/478075#M1122380 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P><STRONG>Type</STRONG></P><P>A00E</P><P>A001</P><P>A009</P><P>M00E</P><P>K009</P><P>M09E</P><P></P><P><STRONG>How to exclude ending with E</STRONG><BR />O/p would be</P><P><STRONG>Type</STRONG></P><P>A001</P><P>A009</P><P>K009</P></BODY></HTML> Tue, 07 Jan 2014 16:22:51 GMT https://community.qlik.com/t5/QlikView/Help/m-p/478075#M1122380 paulwalker 2014-01-07T16:22:51Z Re: Help.. https://community.qlik.com/t5/QlikView/Help/m-p/478076#M1122381 <HTML><HEAD></HEAD><BODY><P>Hi Paul,</P><P></P><P>have a look at String-functions - in particular, LEFT(), RIGHT(), MID()</P><P></P><P>HTH</P><P></P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Tue, 07 Jan 2014 16:24:45 GMT https://community.qlik.com/t5/QlikView/Help/m-p/478076#M1122381 datanibbler 2014-01-07T16:24:45Z Re: Help.. https://community.qlik.com/t5/QlikView/Help/m-p/478077#M1122382 <HTML><HEAD></HEAD><BODY><P>Type:</P><P>LOAD * INLINE [</P><P>Type</P><P>A00E</P><P>A001</P><P>A009</P><P>M00E</P><P>K009</P><P>M09E</P><P>]</P><P>where right(Type,1) &lt;&gt; 'E';</P></BODY></HTML> Tue, 07 Jan 2014 16:24:55 GMT https://community.qlik.com/t5/QlikView/Help/m-p/478077#M1122382 Nicole-Smith 2014-01-07T16:24:55Z Re: Help.. https://community.qlik.com/t5/QlikView/Help/m-p/478078#M1122383 <HTML><HEAD></HEAD><BODY><P>You can use where condition</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">like this </SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><STRONG>where right(Type,1) &lt;&gt; 'E';</STRONG></SPAN></P></BODY></HTML> Tue, 07 Jan 2014 16:31:43 GMT https://community.qlik.com/t5/QlikView/Help/m-p/478078#M1122383 Nagaraju_KCS 2014-01-07T16:31:43Z