3 Replies Latest reply: Oct 13, 2009 10:26 AM by arunpaduva RSS

    rename empty fields en look to other tables

      Can someone tell me what's wrong with my 2 codes:

      Select
      "departement_name"
      "line_of_business"
      from table1;

      Select
      "departement_number"
      from table2;

      if ("table2.departement_number"= '', '4000', "table2.departement_number")
      //Some departements have no departement_numbers, and I wish to give them those the number 4000 automaticly within Qlikview//

       

       

      if ("table1.line_of_business"= 'sales', '1000', as "table2.departement_number")
      //Every sales departement must be shown with a 1000 departement number//

      thx in advace