Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

mcapopa1
New Contributor III

Creating Aging Categories

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'

1 Reply

Re: Creating Aging Categories

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.

See https://help.qlik.com/en-US/sense/February2018/Subsystems/Hub/Content/Scripting/DateAndTimeFunctions...

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'

)))))


Community Browser