topic Re: How to use RIGHT() for string value? in QlikView https://community.qlik.com/t5/QlikView/How-to-use-RIGHT-for-string-value/m-p/1275779#M622434 <HTML><HEAD></HEAD><BODY><P>Sorry bro, but i only need data that start with AB_ and CD_ . how to do that?</P><P></P><P>SubField(PRD_NAME, 'AB_', 2)</P></BODY></HTML> Wed, 01 Feb 2017 18:40:06 GMT jim_chan 2017-02-01T18:40:06Z How to use RIGHT() for string value? https://community.qlik.com/t5/QlikView/How-to-use-RIGHT-for-string-value/m-p/1275773#M622428 <HTML><HEAD></HEAD><BODY><P>Hi guys, </P><P></P><P>i have data as such AB_apple, AB_orange,AB_lemon, CD_chicken, CD_Beef, CD_Fish.</P><P></P><P>my expected result is i only want to show result - apple, orange,lemon WITHOUT the AB_ ?</P><P></P><P>I have&nbsp; tried to write this expression, it didnt work.</P><P></P><P>if(right(fieldname,3)='AB_' ,<SPAN style="font-size: 13.3333px;">fieldname</SPAN>)</P><P></P><P>HElp pls!</P><P></P><P>Rgds</P><P></P><P>Jim</P></BODY></HTML> Wed, 01 Feb 2017 18:29:12 GMT https://community.qlik.com/t5/QlikView/How-to-use-RIGHT-for-string-value/m-p/1275773#M622428 jim_chan 2017-02-01T18:29:12Z Re: How to use RIGHT() for string value? https://community.qlik.com/t5/QlikView/How-to-use-RIGHT-for-string-value/m-p/1275774#M622429 <HTML><HEAD></HEAD><BODY><P>You can try this:</P><P></P><P><STRONG>SubField(fieldname, '_', 2)</STRONG></P></BODY></HTML> Wed, 01 Feb 2017 18:31:28 GMT https://community.qlik.com/t5/QlikView/How-to-use-RIGHT-for-string-value/m-p/1275774#M622429 sunny_talwar 2017-02-01T18:31:28Z Re: How to use RIGHT() for string value? https://community.qlik.com/t5/QlikView/How-to-use-RIGHT-for-string-value/m-p/1275775#M622430 <HTML><HEAD></HEAD><BODY><P>is u again bro. i wonder where r u living, obviously, in earth.</P></BODY></HTML> Wed, 01 Feb 2017 18:32:18 GMT https://community.qlik.com/t5/QlikView/How-to-use-RIGHT-for-string-value/m-p/1275775#M622430 jim_chan 2017-02-01T18:32:18Z Re: How to use RIGHT() for string value? https://community.qlik.com/t5/QlikView/How-to-use-RIGHT-for-string-value/m-p/1275776#M622431 <HTML><HEAD></HEAD><BODY><P>Sunny, </P><P></P><P>i wrote this expression as such : if(SubField(PRD_NAME, '_', 2),PRD_NAME) , not working.</P></BODY></HTML> Wed, 01 Feb 2017 18:34:36 GMT https://community.qlik.com/t5/QlikView/How-to-use-RIGHT-for-string-value/m-p/1275776#M622431 jim_chan 2017-02-01T18:34:36Z Re: How to use RIGHT() for string value? https://community.qlik.com/t5/QlikView/How-to-use-RIGHT-for-string-value/m-p/1275777#M622432 <HTML><HEAD></HEAD><BODY><P>Why do you need if? This should be enough I think:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>SubField(PRD_NAME, '_', 2)</STRONG></SPAN></P></BODY></HTML> Wed, 01 Feb 2017 18:35:47 GMT https://community.qlik.com/t5/QlikView/How-to-use-RIGHT-for-string-value/m-p/1275777#M622432 sunny_talwar 2017-02-01T18:35:47Z Re: How to use RIGHT() for string value? https://community.qlik.com/t5/QlikView/How-to-use-RIGHT-for-string-value/m-p/1275778#M622433 <HTML><HEAD></HEAD><BODY><P>thank you bro!</P></BODY></HTML> Wed, 01 Feb 2017 18:37:54 GMT https://community.qlik.com/t5/QlikView/How-to-use-RIGHT-for-string-value/m-p/1275778#M622433 jim_chan 2017-02-01T18:37:54Z Re: How to use RIGHT() for string value? https://community.qlik.com/t5/QlikView/How-to-use-RIGHT-for-string-value/m-p/1275779#M622434 <HTML><HEAD></HEAD><BODY><P>Sorry bro, but i only need data that start with AB_ and CD_ . how to do that?</P><P></P><P>SubField(PRD_NAME, 'AB_', 2)</P></BODY></HTML> Wed, 01 Feb 2017 18:40:06 GMT https://community.qlik.com/t5/QlikView/How-to-use-RIGHT-for-string-value/m-p/1275779#M622434 jim_chan 2017-02-01T18:40:06Z Re: How to use RIGHT() for string value? https://community.qlik.com/t5/QlikView/How-to-use-RIGHT-for-string-value/m-p/1275780#M622435 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>If(Match(SubField(PRD_NAME, '_', 1), 'AB', 'CD'), <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">SubField(PRD_NAME, 'AB_', 2)</SPAN>)</STRONG></P></BODY></HTML> Wed, 01 Feb 2017 18:46:05 GMT https://community.qlik.com/t5/QlikView/How-to-use-RIGHT-for-string-value/m-p/1275780#M622435 sunny_talwar 2017-02-01T18:46:05Z