topic Re: Ageing in QlikView

Ageing

srinivasa1 — Fri, 16 Nov 2012 03:46:15 GMT

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.

Re: Ageing

its_anandrjs — Fri, 16 Nov 2012 05:48:28 GMT

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

Re: Ageing

sivarajs — Fri, 16 Nov 2012 06:15:19 GMT

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

Re: Ageing

srinivasa1 — Fri, 16 Nov 2012 15:46:00 GMT

Thank for quick reply.

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

thanks

Re: Ageing

srinivasa1 — Fri, 16 Nov 2012 15:46:17 GMT

Thank for quick reply.

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

thanks

Re: Ageing

sivarajs — Mon, 19 Nov 2012 10:24:17 GMT

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

Better go with aggregation function

Re: Ageing

srinivasa1 — Tue, 20 Nov 2012 01:25:43 GMT

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