Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'
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'
)))))