Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
joshakehurst
Partner - Contributor III
Partner - Contributor III

Trim number in Qlik Sense

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".  Example numbers are below. 

  

13137306792
12813582416
12069220880
13153391459
15198425434
12675882895
1 Solution

Accepted Solutions
sunny_talwar

May be this

Right(Left(Number, 4), 3) as Number

View solution in original post

2 Replies
sunny_talwar

May be this

Right(Left(Number, 4), 3) as Number

joshakehurst
Partner - Contributor III
Partner - Contributor III
Author

Thanks - I knew it was something simple, but couldn't sort it out.