Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mahitham
Contributor

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
Esteemed Contributor

Re: Flag creation help

Maybe sthing like:

load EmployeeID, HireDate, TrainingCompletionDate,

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

from source;

1 Reply
omarbensalem
Esteemed Contributor

Re: Flag creation help

Maybe sthing like:

load EmployeeID, HireDate, TrainingCompletionDate,

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

from source;