topic Re: Comparing Multiple Values in QlikView

Comparing Multiple Values

win_anthony — Fri, 10 Apr 2020 01:50:51 GMT

Is it possible in QlikView to compare multiple 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

Re: Comparing Multiple Values

Architect — Sat, 11 Apr 2020 16:25:16 GMT

HI,

if this is a checking between current and previous month only,

from my high-level observation, you can assign two-variable containing these two dynamic months and in the stagging layer can consolidate one table containing both data. Next, introduce a flag column to check if the data corresponding to any ID in two months have a difference in value.

And from Visual Cues, you can add color to the column depending on your flag '1' or '0'.

Re: Comparing Multiple Values

Saravanan_Desingh — Sun, 10 May 2020 00:05:39 GMT

Please check this.

https://community.qlik.com/t5/New-to-QlikView/Comparing-Values-from-the-Same-Field/m-p/1692812#M388145