Cut string on the right side

[rolandg1881]

Hi!

Does anybody knows how ich can cut the right side of a string in qlikview.

For Example i habe the niumver 12683001. I want cut only the last 3 signs so that the new strings look like 12683

Thank you for your help.

Best regards 

Roland

[martinpohl · Accepted solution]

if the number of digits always the same you can say 

left (niumver ,5) as niumver5

otherwise

left(niumver ,len(niumver)-3) as niumver_new

regards

[rolandg1881]

Thank you very much!