topic Re: Trim number in Qlik Sense in App Development https://community.qlik.com/t5/App-Development/Trim-number-in-Qlik-Sense/m-p/1302436#M27659 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Right(Left(Number, 4), 3) as Number</STRONG></P></BODY></HTML> Tue, 11 Apr 2017 18:23:20 GMT sunny_talwar 2017-04-11T18:23:20Z Trim number in Qlik Sense https://community.qlik.com/t5/App-Development/Trim-number-in-Qlik-Sense/m-p/1302435#M27658 <HTML><HEAD></HEAD><BODY><P>I'm trying to come up with a simple way create a variable in my load script to ignore the leading "1" in a number and return the first three numbers to the right of the "1".&nbsp; Example numbers are below.&nbsp; </P><P><SPAN style="font-size: 10pt;">&nbsp;&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 120px;"><TBODY><TR><TD height="20" width="120">13137306792</TD></TR><TR><TD height="20">12813582416</TD></TR><TR><TD height="20">12069220880</TD></TR><TR><TD height="20">13153391459</TD></TR><TR><TD height="20">15198425434</TD></TR><TR><TD height="20">12675882895</TD></TR></TBODY></TABLE></BODY></HTML> Tue, 11 Apr 2017 18:05:58 GMT https://community.qlik.com/t5/App-Development/Trim-number-in-Qlik-Sense/m-p/1302435#M27658 joshakehurst 2017-04-11T18:05:58Z Re: Trim number in Qlik Sense https://community.qlik.com/t5/App-Development/Trim-number-in-Qlik-Sense/m-p/1302436#M27659 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Right(Left(Number, 4), 3) as Number</STRONG></P></BODY></HTML> Tue, 11 Apr 2017 18:23:20 GMT https://community.qlik.com/t5/App-Development/Trim-number-in-Qlik-Sense/m-p/1302436#M27659 sunny_talwar 2017-04-11T18:23:20Z Re: Trim number in Qlik Sense https://community.qlik.com/t5/App-Development/Trim-number-in-Qlik-Sense/m-p/1302437#M27660 <HTML><HEAD></HEAD><BODY><P>Thanks - I knew it was something simple, but couldn't sort it out.&nbsp; </P></BODY></HTML> Tue, 11 Apr 2017 18:37:05 GMT https://community.qlik.com/t5/App-Development/Trim-number-in-Qlik-Sense/m-p/1302437#M27660 joshakehurst 2017-04-11T18:37:05Z