Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
business_intelligence
Contributor III
Contributor III

Get the earliest sale date

I am trying to get the first sale_date that is greater than the signed_up_at date.

I want this stored as a separate table where each customer_ID exists once with the first sale_date. I then want to be able to link on customer_ID to get the rest of the sale dates for a customer.

customer_ID signed_up_at sale_date
123 30/11/2022 01/12/2022
123 30/11/2022 05/12/2022
123 30/11/2022 12/12/2022
124 01/12/2022 06/12/2022
124 01/12/2022 08/12/2022

 

Labels (1)
1 Solution

Accepted Solutions
MendyS
Partner - Creator III
Partner - Creator III

HI @business_intelligence 

Try This - 

Temp:
NoConcatenate
Load customer_ID, Min(sale_date) as sale_dateTemp
Resident Some_Table where sale_date> signed_up_at
Group by customer_ID;

View solution in original post

2 Replies
MendyS
Partner - Creator III
Partner - Creator III

HI @business_intelligence 

Try This - 

Temp:
NoConcatenate
Load customer_ID, Min(sale_date) as sale_dateTemp
Resident Some_Table where sale_date> signed_up_at
Group by customer_ID;

business_intelligence
Contributor III
Contributor III
Author

@MendyS  that worked! thank you 🙂