New/Removed Records between two Snapshots

[carlcimino]

Hello, I am trying to flag items that are new or removed between two snapshots.  

1. The rule for a newly added item is look at all the "Unique ID" 's in the most recent snapshot with match("Pipeline Stage" ,''Identified,'Discovery') that are not in the prior snapshot at all.
2. The rule for a removed item is look at all the "Unique ID" 's in the prior snapshot with match("Pipeline Stage" ,''Identified,'Discovery') that are not in the current snapshot at all.

I have attached how I manually did this in excel as well as the sample data records.  This is similar to https://community.qlik.com/t5/New-to-Qlik-Sense/Identify-removed-records/td-p/1922299 by @vinieme12 with a bit of additional requirements on the look between snapshots.  Any assistance would be appreciated. 

[carlcimino · Accepted solution]

This was solved by using the P() and E() functions.

https://community.qlik.com/t5/QlikView-App-Dev/P-E-and-where-do-you-use-them/td-p/457847

New (In Current not In Prior):
Count(distinct {<[SortOrder]*={"$(=only(SelectedSortOrder))"},[Pipeline Stage]*={'Identified','Discovery'},[Unique ID]*=E({<SortOrder*={"$(=only(SelectedPriorSortOrder))"}>})>} [Unique ID])

Removed (In Prior not In Current):
Count(distinct {<[SortOrder]*={"$(=only(SelectedPriorSortOrder))"},[Pipeline Stage]*={'Identified','Discovery'},[Unique ID]*=E({<SortOrder*={"$(=only(SelectedSortOrder))"}>})>} [Unique ID])