topic Re: How to keep only the last two text? in QlikView https://community.qlik.com/t5/QlikView/How-to-keep-only-the-last-two-text/m-p/906022#M1001808 <HTML><HEAD></HEAD><BODY><P>Right( YourField, 2)</P></BODY></HTML> Wed, 03 Jun 2015 15:34:52 GMT swuehl 2015-06-03T15:34:52Z How to keep only the last two text? https://community.qlik.com/t5/QlikView/How-to-keep-only-the-last-two-text/m-p/906020#M1001806 <HTML><HEAD></HEAD><BODY><P>For Example:</P><P></P><P></P><P>From [Consumer Q1]&nbsp;&nbsp;&nbsp; I need only the&nbsp; [Q1]</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [Sales Q1]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I need only the [Q1]</P><P>&nbsp;&nbsp;&nbsp;&nbsp; [Customer Q2]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I need only the [Q1]</P><P></P><P></P><P>I need only the last two digits!!</P><P></P><P>Need Help!!</P></BODY></HTML> Wed, 03 Jun 2015 15:31:45 GMT https://community.qlik.com/t5/QlikView/How-to-keep-only-the-last-two-text/m-p/906020#M1001806 MuraliPrasath 2015-06-03T15:31:45Z Re: How to keep only the last two text? https://community.qlik.com/t5/QlikView/How-to-keep-only-the-last-two-text/m-p/906021#M1001807 <HTML><HEAD></HEAD><BODY><P>Subfield(TxtField,' ',-1)</P></BODY></HTML> Wed, 03 Jun 2015 15:34:31 GMT https://community.qlik.com/t5/QlikView/How-to-keep-only-the-last-two-text/m-p/906021#M1001807 anbu1984 2015-06-03T15:34:31Z Re: How to keep only the last two text? https://community.qlik.com/t5/QlikView/How-to-keep-only-the-last-two-text/m-p/906022#M1001808 <HTML><HEAD></HEAD><BODY><P>Right( YourField, 2)</P></BODY></HTML> Wed, 03 Jun 2015 15:34:52 GMT https://community.qlik.com/t5/QlikView/How-to-keep-only-the-last-two-text/m-p/906022#M1001808 swuehl 2015-06-03T15:34:52Z Re: How to keep only the last two text? https://community.qlik.com/t5/QlikView/How-to-keep-only-the-last-two-text/m-p/906023#M1001809 <HTML><HEAD></HEAD><BODY><P>What swuehl said is correct try right(YourField, 2)</P></BODY></HTML> Wed, 03 Jun 2015 16:05:17 GMT https://community.qlik.com/t5/QlikView/How-to-keep-only-the-last-two-text/m-p/906023#M1001809 Anonymous 2015-06-03T16:05:17Z