Comparing 2 (or more) Values

[win_anthony]

Is it possible in QlikView to compare string values? My project is to compare current month's employee data vs. previous month's employee data. The goal is to highlight any changes between the 2 months (ex: if a name changes, position change, employee joining/departing, manager change, etc...). If this is possible, how would you approach this? Below are the following examples: March 2020 / April 2020 / Difference between March vs. April 

Mar-20
DateID	EmpID	LastName	FirstName	Position	Manager	City
20200301	10	Doe	John	Cashier	Jordan, Michael	New York
20200301	11	Smith	Jane	Manager	Rogers, Tom	Chicago
20200301	12	Money	Floyd	Dishwasher	Pacquiao, Manny	Las Vegas

Apr-20
DateID	EmpID	LastName	FirstName	Position	Manager	City
20200401	10	Doe	John	Cashier	Jordan, Michael	New York
20200401	11	Rose	Jane	Reg. Mgr	Steven, Jim	Chicago
20200401	13	Bryant	Kobe	Player	Johnson, Magic	Los Angeles

Difference Between April 2020 vs March 2020
Change	EmpID	LastName	FirstName	Old	New	Manager	City
LastName	11	Rose	Jane	Smith	Rose	Steven, Jim	Chicago
Position	11	Rose	Jane	Manager	Reg. Mgr	Steven, Jim	Chicago
Departed	12	Money	Floyd	Dishwasher		Pacquiao, Manny	Las Vegas
Joined	13	Bryant	Kobe		Player	Johnson, Magic	Los Angeles

[Brett_Bleess]

See duplicate post: https://community.qlik.com/t5/QlikView-Scripting/Comparing-Multiple-Values/m-p/1692555#M98794

Regards,
Brett