topic Re: Pending Age in QlikView

Pending Age

Fri, 26 Jul 2013 04:40:25 GMT

Need help on pending Age:

Logic

for Aging: Call logged (SER_Received_DT) from 00 hrs to 12.59 hrs next day aging will be "1" and SER_Received_DT on and after 15 hrs aging should be "0". Next to next day "+1" should be added aging 1 will become "2"and 0 will become "1".

pls help on this...

Re: Pending Age

Fri, 26 Jul 2013 05:29:21 GMT

Pls explain with data.

Regards,

Kabilan K.

Re: Pending Age

Fri, 26 Jul 2013 06:36:02 GMT

Need pending Age in this way...

Example:

1.01.2013 day call logging from 0 hrs to 12.59 hrs:1 day

after 13 hrs to 00.00 hrs:0 day.same it will add like below shown.

2.01.2013

0 hrs to 12.59 hrs:2 day

13 hrs to 00.00 hrs:1 day

3.01.2013

0 hrs to 12.59 hrs:3 day

13 hrs to 00.00 hrs:2day

Re: Pending Age

Fri, 26 Jul 2013 07:19:19 GMT

If I am understanding ur requirement then follow below.

I think ur table like below.

Date

01-01-2013 04:00:00

04-01-2013 14:00:00

Load Date

,Today()-Date+if(Date=today(),1,0) As AM

,Today()-Date+if(time(Date,'hh.ss')>=13.00 and time(Date,'hh.ss')<=23.59,1,0) As PM

From Date table;

Hope it will help U.

Regards,

Kabilan K.