topic Aging in QlikView

Aging

Wed, 20 Feb 2013 11:42:15 GMT

Requires aging of item,supplier,customer.

in MDM module.

item : 0 to 2 days,3 days,4 days and more than 4 days

supplier : 0 to 1 days,2 days,3 days and more than 3 days

customer : same as supplier

Please send the qvw as soon as possible.

Regards,

Thu, 21 Feb 2013 08:13:14 GMT

can anybody help me on this query.

vikasmahajan — Mon, 06 Jan 2014 10:39:13 GMT

Have you got solution for the same ?

Mon, 06 Jan 2014 10:46:07 GMT

Hi,

You can load something like this

IF(AGE >1 AND AGE<= 20, DUAL('1-20',1),

IF(AGE>=21 AND AGE<= 25, DUAL('21-25',2),

IF(AGE>=26 AND AGE<= 30, DUAL('26-30',3),

IF(AGE>=31 AND AGE<= 35, DUAL('31-35',4),

IF(AGE>=36 AND AGE<= 40, DUAL('36-40',5),

IF(AGE>=41 AND AGE<= 45, DUAL('41-45',6),

IF(AGE>=46 AND AGE<= 50, DUAL('46-50',7),

IF(AGE>=51 AND AGE<= 55, DUAL('51-55',8),

IF(AGE>=56 AND AGE<= 60, DUAL('56-60',9),

IF(AGE>60, DUAL('60+',10))))))))))) AS [Age Band]

in your load script. AGE is your Column name.

Thanks,

Selvakumar