Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi i am recieving the field name as the following example:1234
what i would like to do is extract only the number from the field as 1234.
how do i use the trim function in Qlikview to give me the last four spaces from the right hand side only?
Best,
Bradley
right(name,len(right(name,4) )) as name
right(name,len(right(name,4) )) as name