Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor III

i want to fetch First record

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

Tags (2)
3 Replies

Re: i want to fetch First record

May be like this

Today() - Min(Created)

Re: i want to fetch First record

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

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

Honored Contributor II

Re: i want to fetch First record

could you please copy and paste your script load statement ?

Community Browser