Return Unmatched values

Wed, 28 Jul 2010 16:18:17 GMT

Hello,

I wonder if someone would be kind enough to help me.

I have two tables, one that contains employees that have applied to join a bonus scheme in previous years and one table containing employees that have chosen to join this years shceme.

I would like to produce a table showing all those people who are joining this years scheme who have not previously applied to join.

I imagine it to take the form of a table join with a slelection, where the ID# in one table does not exist in the other. I believe in MSAccess this would be classed as an unmatched query

Being relatively new to qlikview I am not sure where to begin so any pointers would be great.

Thank you in advance. Saul.

Return Unmatched values

mike_garcia — Wed, 28 Jul 2010 17:39:32 GMT

Hi,

You can create a Flag in the Load Script, using the Exists function. You would have something like:

-------------------------------------------------------------------------------------------------

PreviousScheme:

Load

...

EmpID

from PreviousSchemeTable.qvd;

NewScheme:

Load

...

EmpID,

If(not Exists(EmpID), 1) as _NewSchemeFlag

from NewSchemeTable.qvd;

-------------------------------------------------------------------------------------------------

You would have to check the syntax, but it gives you the idea.

Hope This Helps.

Mike.

topic Return Unmatched values in QlikView

Return Unmatched values

Return Unmatched values