6 Replies Latest reply: Sep 17, 2014 2:32 AM by Henric Cronström RSS

    ErrorMode not working with missing of single quote

    Gowri Shankar

      Hello experts,

      I have a scenario, please refer to my below script.

       

      SET ErrorMode = 0;

       

      Employees:

      LOAD * INLINE [

          EmpID, Name, Dept

          4405, James, Sales

          4408, David, Finance

          4412, Bobby, HR

          4420, Chan, Sales

          4438, Mike, Human Resource

          4456, Volker, Sales

      ];

       

      SET vHRFilter = "Match(Dept,HR','Human Resource')";

       

      HR_User:

      LOAD EmpID,

        Name as HRUser

      Resident Employees Where $(vHRFilter);

       

      Let vError = Num(ScriptError) &' - '& ScriptErrorDetails;

       

      I have also attached the same qlikview file here for your easy reference.

       

      The actual Match case should be Match(Dept,'HR','Human Resource'); but for testing I purposely skipped the open single quote for HR. By right the SciprtErrorDetails should capture this error, but it is not. Is it a know QlikView issue? Any idea how to over come this kind of scenario? Does it need hot fixes from QlikTech Consultants?

      All you valuable suggestions are most welcome.

       

      Thanks in advance.

      Shankar