Code Fix

[Pomna]

Am new to the Qlik platform and I need to fix a code break where Qlik duplicates duplicates the time worked/entered when an employee moves from one position to another. Any ideas experts?

Thanks

[Gysbert_Wassenaar]

First idea: show us the code.

[swuehl]

Second idea: Read about slowly changing dimensions, start with

https://community.qlik.com/t5/Qlik-Design-Blog/Slowly-Changing-Dimensions/ba-p/1464187

and continue with the referenced tech brief document.

[Pomna]

Thanks. SCD helped put the issue in context but am still  not clear on how to fix it. Attached is the data model