DATE

sagaraperera — Mon, 18 May 2015 08:44:29 GMT

What is the command to get the age analysis between (month 3 to 06) and (06 to 09) and (below 03 month) my script given below.

thanks

sagara

Directory;

BCOD,

DET_DEBT_CODE,

DNAME,

EXCODE,

ME_NAME,

DET_REF_2,

DET_POLICY_NO,

Date (DET_RISK_DATE,'DD/MM/YY') as DET_RISK_DATE,

DAYS, IF(DAYS<=30,'30_DAYS',IF(DAYS<=60,'60_DAYS',IF(DAYS<=90,'90_DAYS',IF(DAYS<=120,'120_DAYS',IF(DAYS<=150,'150_DAYS',IF(DAYS<=180,'180_DAYS',IF(DAYS>180,'OVER_180',0)))))))AS AGE,

DET_DESCRIP,

DET_PRODUCT,

POL_CLA_CODE,

BAL,

FLAG

Re: DATE

datanibbler — Mon, 18 May 2015 09:26:31 GMT

Hi,

for that you can use Interval_Match. That matches intervals you have (0-3 months is one, 3-6 months is another) to the exact age of the items in your fact_table.

HTH

topic DATE in QlikView

DATE

Re: DATE