Where Not Exists

Wed, 01 May 2013 15:28:34 GMT

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

topic Where Not Exists in QlikView

Where Not Exists

Re: Where Not Exists