topic Comparing 2 (or more) Values in QlikView https://community.qlik.com/t5/QlikView/Comparing-2-or-more-Values/m-p/1692554#M455697 <P>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&nbsp;</P><TABLE width="534"><TBODY><TR><TD width="534">Mar-20</TD></TR><TR><TD>DateID</TD><TD>EmpID</TD><TD>LastName</TD><TD>FirstName</TD><TD>Position</TD><TD>Manager</TD><TD>City</TD></TR><TR><TD>20200301</TD><TD>10</TD><TD>Doe</TD><TD>John</TD><TD>Cashier</TD><TD>Jordan, Michael</TD><TD>New York</TD></TR><TR><TD>20200301</TD><TD>11</TD><TD>Smith</TD><TD>Jane</TD><TD>Manager</TD><TD>Rogers, Tom</TD><TD>Chicago</TD></TR><TR><TD>20200301</TD><TD>12</TD><TD>Money</TD><TD>Floyd</TD><TD>Dishwasher</TD><TD>Pacquiao, Manny</TD><TD>Las Vegas</TD></TR></TBODY></TABLE><P>&nbsp;</P><TABLE width="534"><TBODY><TR><TD width="534">Apr-20</TD></TR><TR><TD>DateID</TD><TD>EmpID</TD><TD>LastName</TD><TD>FirstName</TD><TD>Position</TD><TD>Manager</TD><TD>City</TD></TR><TR><TD>20200401</TD><TD>10</TD><TD>Doe</TD><TD>John</TD><TD>Cashier</TD><TD>Jordan, Michael</TD><TD>New York</TD></TR><TR><TD>20200401</TD><TD>11</TD><TD>Rose</TD><TD>Jane</TD><TD>Reg. Mgr</TD><TD>Steven, Jim</TD><TD>Chicago</TD></TR><TR><TD>20200401</TD><TD>13</TD><TD>Bryant</TD><TD>Kobe</TD><TD>Player</TD><TD>Johnson, Magic</TD><TD>Los Angeles</TD></TR></TBODY></TABLE><P>&nbsp;</P><TABLE width="613"><TBODY><TR><TD width="613">Difference Between April 2020 vs March 2020</TD></TR><TR><TD>Change</TD><TD>EmpID</TD><TD>LastName</TD><TD>FirstName</TD><TD>Old</TD><TD>New</TD><TD>Manager</TD><TD>City</TD></TR><TR><TD>LastName</TD><TD>11</TD><TD>Rose</TD><TD>Jane</TD><TD>Smith</TD><TD>Rose</TD><TD>Steven, Jim</TD><TD>Chicago</TD></TR><TR><TD>Position</TD><TD>11</TD><TD>Rose</TD><TD>Jane</TD><TD>Manager</TD><TD>Reg. Mgr</TD><TD>Steven, Jim</TD><TD>Chicago</TD></TR><TR><TD>Departed</TD><TD>12</TD><TD>Money</TD><TD>Floyd</TD><TD>Dishwasher</TD><TD>&nbsp;</TD><TD>Pacquiao, Manny</TD><TD>Las Vegas</TD></TR><TR><TD>Joined</TD><TD>13</TD><TD>Bryant</TD><TD>Kobe</TD><TD>&nbsp;</TD><TD>Player</TD><TD>Johnson, Magic</TD><TD>Los Angeles</TD></TR></TBODY></TABLE> Sat, 16 Nov 2024 18:48:20 GMT win_anthony 2024-11-16T18:48:20Z Comparing 2 (or more) Values https://community.qlik.com/t5/QlikView/Comparing-2-or-more-Values/m-p/1692554#M455697 <P>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&nbsp;</P><TABLE width="534"><TBODY><TR><TD width="534">Mar-20</TD></TR><TR><TD>DateID</TD><TD>EmpID</TD><TD>LastName</TD><TD>FirstName</TD><TD>Position</TD><TD>Manager</TD><TD>City</TD></TR><TR><TD>20200301</TD><TD>10</TD><TD>Doe</TD><TD>John</TD><TD>Cashier</TD><TD>Jordan, Michael</TD><TD>New York</TD></TR><TR><TD>20200301</TD><TD>11</TD><TD>Smith</TD><TD>Jane</TD><TD>Manager</TD><TD>Rogers, Tom</TD><TD>Chicago</TD></TR><TR><TD>20200301</TD><TD>12</TD><TD>Money</TD><TD>Floyd</TD><TD>Dishwasher</TD><TD>Pacquiao, Manny</TD><TD>Las Vegas</TD></TR></TBODY></TABLE><P>&nbsp;</P><TABLE width="534"><TBODY><TR><TD width="534">Apr-20</TD></TR><TR><TD>DateID</TD><TD>EmpID</TD><TD>LastName</TD><TD>FirstName</TD><TD>Position</TD><TD>Manager</TD><TD>City</TD></TR><TR><TD>20200401</TD><TD>10</TD><TD>Doe</TD><TD>John</TD><TD>Cashier</TD><TD>Jordan, Michael</TD><TD>New York</TD></TR><TR><TD>20200401</TD><TD>11</TD><TD>Rose</TD><TD>Jane</TD><TD>Reg. Mgr</TD><TD>Steven, Jim</TD><TD>Chicago</TD></TR><TR><TD>20200401</TD><TD>13</TD><TD>Bryant</TD><TD>Kobe</TD><TD>Player</TD><TD>Johnson, Magic</TD><TD>Los Angeles</TD></TR></TBODY></TABLE><P>&nbsp;</P><TABLE width="613"><TBODY><TR><TD width="613">Difference Between April 2020 vs March 2020</TD></TR><TR><TD>Change</TD><TD>EmpID</TD><TD>LastName</TD><TD>FirstName</TD><TD>Old</TD><TD>New</TD><TD>Manager</TD><TD>City</TD></TR><TR><TD>LastName</TD><TD>11</TD><TD>Rose</TD><TD>Jane</TD><TD>Smith</TD><TD>Rose</TD><TD>Steven, Jim</TD><TD>Chicago</TD></TR><TR><TD>Position</TD><TD>11</TD><TD>Rose</TD><TD>Jane</TD><TD>Manager</TD><TD>Reg. Mgr</TD><TD>Steven, Jim</TD><TD>Chicago</TD></TR><TR><TD>Departed</TD><TD>12</TD><TD>Money</TD><TD>Floyd</TD><TD>Dishwasher</TD><TD>&nbsp;</TD><TD>Pacquiao, Manny</TD><TD>Las Vegas</TD></TR><TR><TD>Joined</TD><TD>13</TD><TD>Bryant</TD><TD>Kobe</TD><TD>&nbsp;</TD><TD>Player</TD><TD>Johnson, Magic</TD><TD>Los Angeles</TD></TR></TBODY></TABLE> Sat, 16 Nov 2024 18:48:20 GMT https://community.qlik.com/t5/QlikView/Comparing-2-or-more-Values/m-p/1692554#M455697 win_anthony 2024-11-16T18:48:20Z Re: Comparing 2 (or more) Values https://community.qlik.com/t5/QlikView/Comparing-2-or-more-Values/m-p/1697872#M455698 <P>See duplicate post:&nbsp;<A href="https://community.qlik.com/t5/QlikView-Scripting/Comparing-Multiple-Values/m-p/1692555#M98794" target="_blank">https://community.qlik.com/t5/QlikView-Scripting/Comparing-Multiple-Values/m-p/1692555#M98794</A></P><P>Regards,<BR />Brett</P> Wed, 29 Apr 2020 19:30:32 GMT https://community.qlik.com/t5/QlikView/Comparing-2-or-more-Values/m-p/1697872#M455698 Brett_Bleess 2020-04-29T19:30:32Z