I did a Left join on 2 tables Gifts & Pledges. Took the fields I wanted from pledges and appended them to gifts.
Then I created a table object in qlikview with a button that decides which things to view Either All Gifts and Payments or Only Payments where the original pledge year = the payment year.
I don't know what action to use to do this.
I tried select in field where [gift campaign year] = [Gift Pledge Campaign Year]
Gift pledge Campaign year was created in my join and append. Not sure if this makes sense.