Calculate Person Age Approaching 18 years

[harika189]

Want to know how to implement a qlik sense script in data load editor to calculate if the persons age is approaching 18 in next 30 days 

[ajaykakkar93]

yes we can do this, find the below backend code

data:
load
  Emp_ID,
  EMP_Name,
  Birthdate,
  [Birthday In This Month],
  [Birthday In Next Month],
  Age
  ;
load
  Emp_ID,
  EMP_Name,
  Birthdate,
  if(Month(Birthdate) = Month(today()) , 'Yes','No' ) as [Birthday In This Month],
  if(Month(Birthdate) = Month(AddMonths(today(),1)) , 'Yes','No' ) as [Birthday In Next Month],
  age(today(),Birthdate)  as Age;
load * Inline [
Emp_ID,EMP_Name,Birthdate
1,A,30/11/2005
2,B,22/09/1993
3,C,18/12/1993
4,D,18/10/1993
];


Exit Script;

Output: