If or where in a chart expression

[#1]

If([Pledge Campaign Year]<[Gift Campaign Year], sum([Gift Amount]), Null())

Trying to use this code in a chart expression to sum only the gifts that have a campaign year < pledge campaign year but it isn't working.

[swuehl]

Well, I assume you can only filter your records using both tables after the JOIN has happened. So first join the two tables, then do a RESIDENT LOAD with the WHERE clause.

[#3]

I am a newbie.  So I do the join without the where then how do I do the resident load?

[swuehl]

Just like the other resident loads in your script.

Something along this snippet:

// load first table

Table1:

LOAD  Key,

           Field1

FROM YourTable1Source;

// join second to first

LEFT JOIN (Table1)

LOAD

        Key,

        Field2

FROM Yourtable2Source;

Result:

NOCONCATENATE           // prevent QV from autoconcatenating

LOAD Key, Field1, Field2

RESIDENT Table1

WHERE Field1 < Field2;     // use your filter

DROP TABLE Table1;