https://community.qlik.com/t5/QlikView/Cut-string-on-the-right-side/m-p/1635968#M733466 <P>if the number of digits always the same you can say&nbsp;</P><P>left (<SPAN>niumver&nbsp;,5) as&nbsp;niumver5</SPAN></P><P><SPAN>otherwise</SPAN></P><P><SPAN>left(niumver&nbsp;,len(niumver)-3) as&nbsp;niumver_new</SPAN></P><P><SPAN>regards</SPAN></P> Wed, 16 Oct 2019 10:57:30 GMT martinpohl 2019-10-16T10:57:30Z https://community.qlik.com/t5/QlikView/Cut-string-on-the-right-side/m-p/1635961#M733465 <P>Hi!</P><P>Does anybody knows how ich can cut the right side of a string in qlikview.</P><P>For Example i habe the niumver 12683001. I want cut only the last 3 signs so that the new strings look like 12683</P><P>Thank you for your help.</P><P>Best regards&nbsp;</P><P>Roland</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Cut-string-on-the-right-side/m-p/1635961#M733465 rolandg1881 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Cut-string-on-the-right-side/m-p/1635968#M733466 <P>if the number of digits always the same you can say&nbsp;</P><P>left (<SPAN>niumver&nbsp;,5) as&nbsp;niumver5</SPAN></P><P><SPAN>otherwise</SPAN></P><P><SPAN>left(niumver&nbsp;,len(niumver)-3) as&nbsp;niumver_new</SPAN></P><P><SPAN>regards</SPAN></P> Wed, 16 Oct 2019 10:57:30 GMT https://community.qlik.com/t5/QlikView/Cut-string-on-the-right-side/m-p/1635968#M733466 martinpohl 2019-10-16T10:57:30Z https://community.qlik.com/t5/QlikView/Cut-string-on-the-right-side/m-p/1636038#M733467 <P>Thank you very much!</P> Wed, 16 Oct 2019 12:12:46 GMT https://community.qlik.com/t5/QlikView/Cut-string-on-the-right-side/m-p/1636038#M733467 rolandg1881 2019-10-16T12:12:46Z