topic Re: How to skip last 3 digit in the data? in QlikView https://community.qlik.com/t5/QlikView/How-to-skip-last-3-digit-in-the-data/m-p/748160#M1031146 <HTML><HEAD></HEAD><BODY><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/cool.png" /> thank you. </P></BODY></HTML> Thu, 05 Feb 2015 06:56:26 GMT 2015-02-05T06:56:26Z How to skip last 3 digit in the data? https://community.qlik.com/t5/QlikView/How-to-skip-last-3-digit-in-the-data/m-p/748156#M1031142 <HTML><HEAD></HEAD><BODY><P>Hi QV Team,</P><P>I need to skip the last 3 digits. Help me out.</P><P><IMG alt="2-5-2015 12-13-22 PM.png" class="image-1 jive-image" src="/legacyfs/online/77164_2-5-2015 12-13-22 PM.png" style="height: auto;" /></P></BODY></HTML> Thu, 05 Feb 2015 06:46:17 GMT https://community.qlik.com/t5/QlikView/How-to-skip-last-3-digit-in-the-data/m-p/748156#M1031142 2015-02-05T06:46:17Z Re: How to skip last 3 digit in the data? https://community.qlik.com/t5/QlikView/How-to-skip-last-3-digit-in-the-data/m-p/748157#M1031143 <HTML><HEAD></HEAD><BODY><P>Left(Field,Len(Field)-3)</P></BODY></HTML> Thu, 05 Feb 2015 06:49:41 GMT https://community.qlik.com/t5/QlikView/How-to-skip-last-3-digit-in-the-data/m-p/748157#M1031143 tresB 2015-02-05T06:49:41Z Re: How to skip last 3 digit in the data? https://community.qlik.com/t5/QlikView/How-to-skip-last-3-digit-in-the-data/m-p/748158#M1031144 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Like this???</P><P></P><P>Thanks,</P><P>AS</P></BODY></HTML> Thu, 05 Feb 2015 06:55:06 GMT https://community.qlik.com/t5/QlikView/How-to-skip-last-3-digit-in-the-data/m-p/748158#M1031144 amit_saini 2015-02-05T06:55:06Z Re: How to skip last 3 digit in the data? https://community.qlik.com/t5/QlikView/How-to-skip-last-3-digit-in-the-data/m-p/748159#M1031145 <HTML><HEAD></HEAD><BODY><P>Hi Murali,</P><P></P><P>Please try this,</P><P></P><P>Mid(Sales Order#,1,( Len(<SPAN style="font-size: 13.3333330154419px;">Sales Order#</SPAN>)-3))</P><P></P><P>Warm Regards,</P><P>Joshmi</P></BODY></HTML> Thu, 05 Feb 2015 06:55:14 GMT https://community.qlik.com/t5/QlikView/How-to-skip-last-3-digit-in-the-data/m-p/748159#M1031145 2015-02-05T06:55:14Z Re: How to skip last 3 digit in the data? https://community.qlik.com/t5/QlikView/How-to-skip-last-3-digit-in-the-data/m-p/748160#M1031146 <HTML><HEAD></HEAD><BODY><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/cool.png" /> thank you. </P></BODY></HTML> Thu, 05 Feb 2015 06:56:26 GMT https://community.qlik.com/t5/QlikView/How-to-skip-last-3-digit-in-the-data/m-p/748160#M1031146 2015-02-05T06:56:26Z