topic Re: age is not display in QlikView

age is not display

Tue, 19 Jan 2016 13:00:26 GMT

Hi all

Employees:

LOAD * INLINE [

Member,DateOfBirth

John,28/03/1989

Linda,10/12/1990

Steve,5/2/1992

Birg,31/3/1993

Raj,19/5/1994

Prita,15/9/1994

Su,11/12/1994

Goran,2/3/1995

Sunny,14/5/1996

Ajoa,13/6/1996

Daphne,7/7/1998

Biffy,4/8/2000

];

AgeTable:

Load *,

age('19/01/2016', DateOfBirth) As Age

Resident Employees;

Drop table Employees;

Re: age is not display

Anonymous — Tue, 19 Jan 2016 13:05:06 GMT

Qkukview maynot recognoize the date format

try to define it yourself

I succeeded with this expression

age(date#('19/01/2016','DD/MM/YYYY'),date#(DateofBirth'DD/MM/YYYY'))

Re: age is not display

sunny_talwar — Tue, 19 Jan 2016 13:05:18 GMT

Try this:

SET DateFormat='DD/MM/YYYY';

Employees:

LOAD * INLINE [

Member,DateOfBirth

John,28/03/1989

Linda,10/12/1990

Steve,5/2/1992

Birg,31/3/1993

Raj,19/5/1994

Prita,15/9/1994

Su,11/12/1994

Goran,2/3/1995

Sunny,14/5/1996

Ajoa,13/6/1996

Daphne,7/7/1998

Biffy,4/8/2000

];

AgeTable:

Load *,

Age('19/01/2016', DateOfBirth) As Age

Resident Employees;

Drop table Employees;

Re: age is not display

Chanty4u — Tue, 19 Jan 2016 13:05:38 GMT

pfa

Re: age is not display

marcus_sommer — Tue, 19 Jan 2016 13:07:10 GMT

You will need something like this:date(date#(DateOfBirth, 'DD/MM/YYYY'), 'DD/MM/YYYY') and maybe the same with today:

AgeTable:

Load *,

age(date(today(), 'DD/MM/YYYY'), date(date#(DateOfBirth, 'DD/MM/YYYY'), 'DD/MM/YYYY')) As Age

Resident Employees;

Drop table Employees;

Re: age is not display

Anonymous — Tue, 19 Jan 2016 13:09:01 GMT

may be this, remove single quotation?

AgeTable:

Load *,

age('19/01/2016', DateOfBirth) As Age

Resident Employees;

Drop table Employees;

Re: age is not display

Tue, 19 Jan 2016 13:31:57 GMT

hi sunny thnx you for repaly,

Age('19/01/2016', DateOfBirth) As Age

it display only year

Is possible to display complete age (dd-mm-yy)

Re: age is not display

Anonymous — Tue, 19 Jan 2016 13:34:33 GMT

With age() it would not be possible as it return only year difference

Re: age is not display

Tue, 19 Jan 2016 13:38:15 GMT

hi Balraj,

There is any other way(other function) to calculate complete date format

Re: age is not display

sunny_talwar — Tue, 19 Jan 2016 13:38:33 GMT

May be this:

SET DateFormat='DD/MM/YYYY';

Employees:

LOAD * INLINE [

Member,DateOfBirth

John,28/03/1989

Linda,10/12/1990

Steve,5/2/1992

Birg,31/3/1993

Raj,19/5/1994

Prita,15/9/1994

Su,11/12/1994

Goran,2/3/1995

Sunny,14/5/1996

Ajoa,13/6/1996

Daphne,7/7/1998

Biffy,4/8/2000

];

AgeTable:

Load *,

Age('19/01/2016', DateOfBirth) As Age,

TimeStamp('19/01/2016' - DateOfBirth, 'YY') as Years,

TimeStamp('19/01/2016' - DateOfBirth, 'MM') as Months,

TimeStamp('19/01/2016' - DateOfBirth, 'DD') as Days

Resident Employees;

Drop table Employees;

EDIT: With reference from Age Calculation | Qlik Community

Re: age is not display

Anonymous — Tue, 19 Jan 2016 13:40:20 GMT

Already done by Sunny T