date

[sagaraperera]

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

[Gysbert_Wassenaar]

Create a chart with AGE as dimension and Count(AGE) as expression. If that's not what you're looking for please explain your requirements. Posting a qlikview document that demonstrates things would be helpful.