4 Replies Latest reply: Mar 27, 2017 10:27 AM by Edward Carlile RSS

    Add calculate field

    Edward Carlile

      I'm trying to add a calculate field to a new sheet I'm importing. its a simple If statement like this:

       

      if(len([Inventory Organization])=1,'00'&[Inventory Organization])

       

      Basically if the organization has only 1 character in it, I want to add two leading zeros. I've used this many times in excel with no problem. Qlik keeps giving me an error on the = sign saying 'Unrecognized sybol:='.

       

      Any help would be much appreciated.