1 Reply Latest reply: May 1, 2013 2:12 PM by David Koschei RSS

    Where Not Exists

    David Koschei

      Table1:

      %Table1ID

      RequestNumber,

      RequestDepartment

       

      Table2:

      %Table2ID

      RequestNumber,

      UserName,

      HoursSpent

       

      I've tried both connecting the tables on RequestNumber, as well as creating a Fact table with %Table1ID, %Table2ID, and RequestNumber.

       

      What I'm trying to do is show a Sum of HoursSpent per RequestDepartment (and be able to "qlik" UserNames).  If RequestDepartment is null in Table1, I replace it with 'None'.  However, if RequestNumber in Table2 is not found in Table1, I want RequestDepartment to say 'Request Not Found', but still show the Sum of HoursSpent toward 'Request Not Found'.

       

      How can I go about doing this?  Basically, RequestNumber can be typed incorrectly in table 2 (it won't exist in table1), and I want to be able to click on those to reveal them.

       

       

      Note: It's kind of like I want an outer join, but to replace nulls with values so I can click them.  I don't think I want to join the tables for this, though, but I will if it's the only way