topic Get the earliest sale date in QlikView

Get the earliest sale date

business_intelligence — Mon, 12 Dec 2022 09:33:32 GMT

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

Re: Get the earliest sale date

MendyS — Mon, 12 Dec 2022 13:39:05 GMT

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;

Re: Get the earliest sale date

business_intelligence — Tue, 20 Dec 2022 13:38:54 GMT

@MendyS that worked! thank you 🙂