Identify removed records

[BI_Dev]

@vinieme12 Hi - I have a similar requirement as

https://community.qlik.com/t5/Visualization-and-Usability/Identify-removed-records/m-p/1922299

where I have to show #of records added & terminated each month.

using this if(ID_2=Peek(ID_2) and isnull(check),'Terminated','Added') as status

Here ID 401 is only added in 3/1/2025 - However it is showing Added & Terminated from Dec, Jan, Feb as well. How can I fix that ?

386 is Terminated in Feb and that is showing correct.

Thank you much.

@rwunderlich@Chanty4u @stalwar1 @Lech_Miszkiewicz @vinieme12

[Chanty4u]

Try this 

TempData:

LOAD 

    ID_2, 

    Month,

    check

FROM YourSource

ORDER BY ID_2, Month;

FinalData:

LOAD

    ID_2, 

    Month,

    check,

    If(ID_2 = Peek(ID_2) AND isnull(check), 'Terminated', 'Added') AS status

RESIDENT TempData

ORDER BY ID_2, Month;

[BI_Dev]

That did not work

[BI_Dev]

@Chanty4u @vinieme12  - any thoughts on this ?