topic Re: Age Calculation in QlikView

Age Calculation

upaliwije — Wed, 08 Apr 2015 08:50:56 GMT

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

set Vagedate=03/31/2015;

claim:

LOAD YEAR,

MONTH,

PRODUCT AS PRD_CODE,

// date(REPO_DATE,'DD-MMM-YY')AS REPO_DATE,

//date(LOSS_DATE,'DD-MMM-YY')AS LOSS_DATE,

FLOOR(REPO_DATE)AS REPO_DATE,

FLOOR(LOSS_DATE)AS LOSS_DATE,

Vagedate-FLOOR(REPO_DATE)as age,

I have written above script for my QV document with Age as a field (highlighted in red) But it is not working. Pls help me to correct the error

simsondevadoss — Wed, 08 Apr 2015 08:56:32 GMT

$(Vagedate)-FLOOR(REPO_DATE)

Wed, 08 Apr 2015 09:00:10 GMT

set Vagedate=Date(Makedate(2015,,03,31),'M/D/YYYY');

claim:

LOAD YEAR,

MONTH,

PRODUCT AS PRD_CODE,

// date(REPO_DATE,'DD-MMM-YY')AS REPO_DATE,

//date(LOSS_DATE,'DD-MMM-YY')AS LOSS_DATE,

FLOOR(REPO_DATE)AS REPO_DATE,

FLOOR(LOSS_DATE)AS LOSS_DATE,

$(Vagedate)-FLOOR(REPO_DATE)as age,

Anonymous — Wed, 08 Apr 2015 09:01:32 GMT

interval(Today() - date([REPO_DATE]),'d')

you can use your column in place of today.

Thanks

BKC

upaliwije — Wed, 08 Apr 2015 09:07:50 GMT

Thanks all