Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
srinivasa1
Creator II
Creator II

Ageing

Hi

Can any suggest how i can  do best ageing for attached qvw file. and i need to calculate ovell ageing for call id 1 and 2 as below

total duration it  should be like for call id 1 it solud be total duration of status thats 30 min[0-1] nd for call id 2 it shold be (6.50)  fall duration under > [4]

Thanks in advance.

6 Replies
its_anandrjs

Hi,

In Resident table write some thing like this for ageing

Load

[Call Id],

if (Hour(Duartion) <=1,'[0-1]',

if (Hour(Duartion) >=1 and Hour(Duartion)<=2 ,'[2-2]',

if (Hour(Duartion) >=2 and Hour(Duartion)<=3 ,'[2-3]',

if (Hour(Duartion) >=3 and Hour(Duartion)<=4 ,'[3-4]',

if (Hour(Duartion) >=4 and Hour(Duartion)<=5 ,'[4-5]',

if (Hour(Duartion) >=5 and Hour(Duartion)<=6 ,'[5-6]'))))))

as ageing

Resident Book1;

Regards,

Anand

sivarajs
Specialist II
Specialist II

Not sure what you exactly looking for, check and let me know

srinivasa1
Creator II
Creator II
Author

Thank for quick reply.

its helpfull one but why its not filtred as for ageing selection

thanks

srinivasa1
Creator II
Creator II
Author

Thank for quick reply.

its helpfull one but why its not filtred as for ageing selection

thanks

sivarajs
Specialist II
Specialist II

When you filter by age selection obviously it will show as per hour selection.

Better go with aggregation function

srinivasa1
Creator II
Creator II
Author

Hi Sivaraj,

Thanks for your suggestion do you guide how i can add this into my attached sample file

it should do aggregartion or sum of duration for selected ageing

Thanks