Latest Salary of the employee

[qlikviewwizard]

Hi All,

How to implement SCD for the below scenario.

I want to pick latest designation and Salary of the employee.

Thanks in advance.

EMPNO	ENAME	JOB	MGR	HIREDATE	PRMOTIONDATE	SAL	COMM	DEPTNO
7369	JONES	Jr Engineer	7902	12/17/2000 0:00	8/29/2002 0:00	800	NULL	20
7369	JONES	Engineer	7902	10/23/2003 0:00	11/14/2010 0:00	1600	300	30
7369	JONES	Sr Engineer	7902	11/15/2010 0:00	4/1/2015 0:00	1250	500	30
7369	JONES	MANAGER	7839	4/2/2015 0:00	9/9/9999 0:00	2975		20

[Gysbert_Wassenaar · Accepted solution]

You can use the firstsortedvalue function. See attached example.

[qlikviewwizard]

Many Thanks QV Guru