Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Panv
Contributor II
Contributor II

Determining which values in field got removed between two dates

hi, I have a list of email subscribers and a time series weekly snapshot date of when those subscribers exist.

Data structure is as such:

Email | Date

Test@test.com | 11/22/2020

Abcd@test.com | 11/22/2020

123@test.com | 11/22/2020

Abcd@test.com | 11/29/2020

In qlik sense load script, every week I want to isolate which users unsubscribed by comparing the email list from 2 dates ago to email list from most recent date.  I need to isolate just these users who lose access so I can do further analysis and join them in some other tables.

Based on given example above, the result should be:

Test@test.com

123@test.com

Since both of these emails existed on 22nd but no longer exist on list in 29th.

How can I go about doing this as the date for both is in one field in the table?

 

1 Reply
Vegar
MVP
MVP

If you are doing this in the script then you could do this by following these steps. 

Load all email from last date (11/29/2020) 

Noconcatenate Load all emails from the previous date (11/22/2020) where not exsist email in first load.

Drop first load table.