Best way to show differences between two similar data sets

[#1]

I am analyzing the changes in user permissions in a single system from two points in time: today and one year ago.

Both data sets have the same 3 columns: Name (user role), Permission, and Level (read, write, edit). I have loaded to prevent syn keys.

1. There were changes in the available Names (role). Some appear one year ago and not today, while some appear today but not a year ago. This is easy for me to analyze and I already have the delta.

2. Some Names (roles) have different permissions, and perhaps even different levels between the two time periods. This is the hard part. How an I show the differences in a QlikView--either using flags or colors or some other method? Alternate States?

     E.g., AP Manager today has "Accounts Payable Graphing" permissions, but did not 1 year ago.

Below is a sample of the data set, to a data set of about 80k rows. Thanks

Name	Permission	Level
AP Accountant  - Bel	Account Detail	View
AP Accountant  - Bel	Accounts	View
AP Accountant  - Bel	Accounts Payable	View
AP Accountant  - Bel	Accounts Payable Graphing	View
AP Accountant  - Bel	Accounts Payable Register	View
AP Accountant  - Bel	Accounts Receivable Register	View
AP Accountant  - Bel	Allocation Schedules	Edit
Sales Administrator	Tasks	Full
Sales Administrator	Team Selling Contribution	Full
Sales Administrator	Track Messages	Edit
Sales Administrator	Unbilled Receivable Registers	View
Sales Administrator	Units	View
Sales Administrator	Upsell Assistant	Full
Sales Administrator	Upsell Setup	Full
Sales Administrator	Upsell Wizard	Full
Sales Administrator	Web Services	Full
Sales Administrator	Work Calendar	View
Sales Administrator - SAML	Accounts Payable Register	View
Sales Administrator - SAML	Accounts Receivable	View
Sales Administrator - SAML	Accounts Receivable Register	View
Sales Administrator - SAML	Bank Account Registers	View
Sales Administrator - SAML	Calendar	Edit
Sales Administrator - SAML	Companies	Full
Sales Administrator - SAML	Competitors	Full
Sales Administrator - SAML	Contact Roles	Full
Sales Administrator - SAML	Contacts	Full
Sales Administrator - SAML	Contract	Full
Sales Administrator - SAML	Contract Item	Full

[swuehl]

John has created some samples for this some time ago, e.g.

How to compare 2 tables and put non-matching results?

Hope this helps,

Stefan