Creating Aging Categories

mcapopa1 — Sun, 18 Mar 2018 18:23:27 GMT

I have Support Case aging data but I need to put them in to aging categories (i.e. < 2days, 2 - 15 days, 15-30 days, 30-60, >60, etc.)

I thought it would be this simple:

=If([Age (Days)]<2,'<2', If([Age (Days)]<15,'2-15', If([Age (Days)]<30,'15-30', IF([Age (Days)]<60,'30-60', If([Age (Days)]>60,'>60'

Re: Creating Aging Categories

Anonymous — Sun, 18 Mar 2018 18:38:04 GMT

The Qlik Age() function takes 2 parameters and returns the numbers of completed years,

So I think it not the correct function to use and by only passing it one parameter will fail.

If your Days field contains a number of days then may use something like this

= If ( [Days] < 2, '<2'

, If ( [Days] < 15 , '2-15'

, If ( [Days] < 30 , '15-30'

, If ( [Days] < 60 , '30-60'

, If ( [Days] > 60 , '>60'

)))))