Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
sweetlisa1217
Contributor II
Contributor II

Help with data load - date comparison with 2 tables

Fairly new at this and trying a different kind of load with data load editor. 

I have a table loaded (40 records) , that has Client ID and a "Go Live" date unique to each client.

Have another table with Referrals that have a date and Client ID, and only want to load records where the Referral Date is greater than or equal to the respective clients "Go Live" date. 

Can't seem to figure out the right approach for this. Any suggestions?

1 Reply
felipedl
Partner - Specialist III
Partner - Specialist III

You could join the two tables, giving the client id as key to get the referral date associated with the go live.

Something like:

 

go_live:

load go_live_date,client_id from [whatever];

left join(go_live)

load referral_date,client_id from [whatever];

 

NoConcatenate

data:

load * from go_live where go_live_date >= referral_date;