topic Re: Identify removed records in App Development

Identify removed records

BI_Dev — Mon, 07 Apr 2025 15:17:10 GMT

@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

Re: Identify removed records

Chanty4u — Mon, 31 Mar 2025 18:29:26 GMT

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;

Re: Identify removed records

BI_Dev — Mon, 31 Mar 2025 20:25:11 GMT

That did not work

Re: Identify removed records

BI_Dev — Wed, 02 Apr 2025 13:49:15 GMT

@Chanty4u @vinieme12 - any thoughts on this ?