New/Removed Records between two Snapshots

carlcimino — Mon, 18 Jul 2022 20:44:42 GMT

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

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.
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.

Re: New/Removed Records between two Snapshots

carlcimino — Tue, 09 Aug 2022 15:37:12 GMT

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])

topic Re: New/Removed Records between two Snapshots in App Development

New/Removed Records between two Snapshots

Re: New/Removed Records between two Snapshots