Qlik Community

Ask a Question

New to Qlik Sense

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

cancel
Showing results for 
Search instead for 
Did you mean: 
Taylorcc
Contributor III
Contributor III

Date & Min function to create a new field in script

Hello

Is there a way i can use this logic to create a new field in the script? 

 

Date(Min([service_contact_date],episode_key)) as Referral_Commenced_Date

I want to use the first service contact date of each epsiode as their referral commenced date.. 

 

Thank you 

Labels (3)
1 Reply
Kushal_Chawda

try below

Data:
load [service_contact_date],
episode_key,
.....
FROM Source ;

left join(Data)
load episode_key,
Date(Min([service_contact_date])) as Referral_Commenced_Date
Resident Data
group by episode_key;