Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mahitham
Creator II
Creator II

Flag creation help

Hi Experts,

Can any one please help me on below requirement.

I have the fields like below.

Employee ID    Hire Date          Training completion date

125896              14/08/2017        28/02/2018

486593              14/05/2018      18/05/2018

I have to create a Flag with two records Completed or Not completed.

When the employee completed the training within 30days from the Hire date it has to be flag as Completed else Not ccompleted.

Please help me on this.

Thanks in advance.

1 Solution

Accepted Solutions
OmarBenSalem

Maybe sthing like:

load EmployeeID, HireDate, TrainingCompletionDate,

if( TrainingCompletionDate-HireDate <=30,'Completed','Not Completed') as Flag

from source;

View solution in original post

1 Reply
OmarBenSalem

Maybe sthing like:

load EmployeeID, HireDate, TrainingCompletionDate,

if( TrainingCompletionDate-HireDate <=30,'Completed','Not Completed') as Flag

from source;