aging interval

BRI — Mon, 26 Jan 2026 18:19:17 GMT

hi, I'm trying to group my tickets on the basis of aging in day (today-Open_time) with something like this but is not working

I need then to use AGING as dimension on charts

LAST_DATA:
NoConcatenate
LOAD [Incident ID],
[Open Time],

(Day(Today())-Day([Open Time])) as DD_difference,
if((DD_difference)<=7,'0-7',
if(DD_difference>=8 and DD_difference<=15,'8-15',
if(DD_difference>=16 and DD_difference<=30,'16-30',
if(DD_difference>=31 and DD_difference<=45,'31-45',
if(DD_difference>=46 and DD_difference<=90,'46-90','91 and more'))))) as AGING,

thanks for the support

ciao

Bri

Re: aging interval

BRI — Thu, 29 Jul 2021 15:34:41 GMT

solved 😉

topic aging interval in QlikView

aging interval

Re: aging interval