topic Re: Show all name excluded in table 2. in QlikView

Show all name excluded in table 2.

Sat, 29 Sep 2012 02:02:14 GMT

Good Day Sir.

I like to show the all the person who did not receive bonus from year 2012 month july.

Table 1:

Table 2: (This are the persons who will receive bonus)

So the result will be

Please give me some idea.

Thank you in advance

swuehl — Sat, 29 Sep 2012 11:56:54 GMT

I assume you want to see Cyril instead of Russel in No bonus table, right?

If you can do it in the script, try adding (after the LOAD of TABLE1 and TABLE2):

NOBONUS:

LOAD Name as [No Bonus] Resident TABLE1 where not exists(Bonus, Name);

Assuming that Bonus is the field name in TABLE2 and Name the field name in TABLE1.

Mon, 01 Oct 2012 02:07:51 GMT

Good Day,

Yes sir, but it does not work.

The No bonus have no output.

Mon, 01 Oct 2012 04:24:59 GMT

Hi,

Just to clear, Is "Name" and "Bonus" 2 separate fields in a same table? or are they loaded from 2 separate tables?

if they are loaded from 2 different table then Mr swuehl's answer should be correct.

Regards,

Alex

Mon, 01 Oct 2012 04:28:14 GMT

they loaded from 2 separate tables

sivarajs — Mon, 01 Oct 2012 05:20:33 GMT

Above should work dont know how you are using

Check the attached file ,that might be what you are looking for