Solved: Re: Comparing Values from the Same Field - Qlik Community

win_anthony · ‎2020-04-10

Is it possible to compare values that are within the same dimension field? The goal is to compare employee data from the current month vs previous month (ex: if a name changes, position change, employee joining/departing, manager change, etc...) and have it reflected as a table (target output is at the bottom of the example data tables). How would you approach this? Is it even possible?

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

Saravanan_Desingh · ‎2020-04-11

Hi,

This is not foolproof solution. But you can try something like this.

View solution in original post

Saravanan_Desingh · ‎2020-04-11

Hi,

This is not foolproof solution. But you can try something like this.

win_anthony · ‎2020-04-12

This was exactly what I needed to help me structure to my current situation. The best learning tool for me is to see how the script is set up and dissect to understand how it all works. Cheers to you and so much gratitude!

Thank you!

ArjunChandra · ‎2020-04-28

Hi, @win_anthony

Have you got the solution for this post. If so, could you please share it with me. I am also having same scenario