Discussion Board for collaboration related to QlikView App Development.
I have a field name, called [Line item]. I want to trim the last 10 characters in that field.
What is the scripting to do this?
I like to inculde the Trim function in case there are beginning or trailing blanks:
Left( [Line item], Len( Trim( [Line item]) ) - 10)
View solution in original post
Try the following expression.
Left([Line Item], Len([Line Item])-10)
=left([Line item], len([Line item]) -10)
We don't have direct function to achieve this. We can use below expression.
trim(replace([Line Item],right([Line Item],10),' '))