8 Replies Latest reply: Dec 16, 2013 9:04 AM by Mavrinder Dhothar RSS

    Loading issue - involving IF statement


      Hey guys,

       

      I'm trying to load the following script into Qlikview:

       

      Load

      [Client Name] As Client_Name,

      [Account Number],
      [Portfolio Name],
      if(len(Client_Name) = 0, 'Fail','Pass') as Client_Name_No_Data
      //     if([Client Name] = "0", 'Fail','Pass') as Client_Name_Wrong_Data,
      //     if(sum([Client Name]) > 0, 'Numerical','Alphabetical') as [Alphabetical/Numerical],

      From

       

      Having issues as it wont recognise the 'Client Name'. I've tried it without renaming [Client Name] As Client_Name as well. When loading with out the If Statement - it works fine.

       

      Can anybody assist please?

       

      Kind Regards

       

      Mav