i want to fetch First record

[Anonymous]

hi qlikers

i am using Qlik sense and i want to show Employee hiring date from Created column and then i want to present how many days & months & years .

when i am using below function it returns Null record

now() - First(Created)

note i am execute previous code in Expression Visualization because when i am trying to load it in script it shows as Invalid  Expression

now() - Firstvalue(Created) as EmployeeAge

[sunny_talwar]

May be like this

Today() - Min(Created)

[sunny_talwar]

For getting them in Month, Year, Days, you can look here

How to convert number of days into Month and Year | Qlik Community

[agigliotti]

could you please copy and paste your script load statement ?