topic Inner Join issues in QlikView

Inner Join issues

Wed, 12 May 2010 19:31:54 GMT

I am a new QV user and have the following question.

I have following 2 QVDs. I did inner join and stored it in the table.

The first QVD has for example 200 rows and 2nd has 100 rows. I need to get the common records from the 2 QVDs. I did the inner join as in the following. The result set get me 100 or less records. right? Am I doing this right?

SalesSubSet:

LOAD

DivDist,

DivItem,

Date,

Sum(ShipQty) as DistShipQty

FROM $(MBAQVDMaster)DF.qvd(qvd)

Group by DivDist, DivItem, Date;

Inner Join

LOAD

DivDist,

DivItem,

Date,

Sum(Qty) as MBAShippedQty

FROM $(MBAQVDMaster)MBAQ.qvd(qvd)

Group by DivDist, DivItem, Date;

STORE SalesSubSet INTO $(MBAQVDMaster)MacSubSet.qvd;

Inner Join issues

Anonymous — Wed, 12 May 2010 20:13:02 GMT

Try this, note change on the Inner Join part.

SalesSubSet:

LOAD

DivDist,

DivItem,

Date,

Sum(ShipQty) as DistShipQty

FROM $(MBAQVDMaster)DF.qvd(qvd)

Group by DivDist, DivItem, Date;

Inner Join (SalesSubSet)

LOAD

DivDist,

DivItem,

Date,

Sum(Qty) as MBAShippedQty

FROM $(MBAQVDMaster)MBAQ.qvd(qvd)

Group by DivDist, DivItem, Date;

STORE SalesSubSet INTO $(MBAQVDMaster)MacSubSet.qvd;

Inner Join issues

Wed, 12 May 2010 20:23:25 GMT

Thanks Rodrick. I will try this and will get back to you.