2 Replies Latest reply: Apr 11, 2017 2:37 PM by Josh Akehurst RSS

    Trim number in Qlik Sense

    Josh Akehurst

      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