5 Replies Latest reply: May 16, 2013 6:54 AM by Peter Schulz RSS

    Cutting off leading zeros

    Peter Schulz



      I have a problem with some fields, having leading zeros.


      For example a field like OrderNo..


      In source 1 the OrderNo. looks like: 00001234567, 00012345678


      In source 2 the OrderNo. looks like: 1234567, 12345678


      Qlikview don't seem to have a problem with that, but is there a solution to cut off the leading zeroes or to define a lenght e.g. of 14 and fill with zeros?


      Or is it unnecessary to care about this?


      Thanks for any advice.



      - PS -