topic Re: How to count consecutive working dates? in QlikView

How to count consecutive working dates?

Wed, 12 Mar 2014 06:01:36 GMT

Hi ,

I want to count number of consecutive dates having data,if one user working more than 6 consecutive days then consider that agent is count one. otherwise if any agent worked 5 days after leave then no need to count that agent.

for more clarification see Example below:

Agent Dates
1 2 3 4 5 6 7 8 9 10

A 9:00 8:57 7:00 8:34 7:59 8:23 8:59 - 8:47 9:02

B - 7:12 8:23 10:06 6:56 7:34 8:14 - - 8:34

C 7:00 8:45 - 8:57 8:12 7:12 7:45 6:43 7:51 7:34

here i need answer is count of agnets working more than 6 days:2(A and C).

Can u suggest how to write expression for this???????????

I need agents count for monthly basis.

Thanks,

Ashok.

Re: How to count consecutive working dates?

tresB — Wed, 12 Mar 2014 06:25:01 GMT

May be like attached sample.

update: a bit correction was needed. please refer second attachment.

Re: How to count consecutive working dates?

er_mohit — Wed, 12 Mar 2014 06:47:33 GMT

@See the attached file

Re: How to count consecutive working dates?

Thu, 13 Mar 2014 08:07:00 GMT

Hi Tresesco,

Thank u somuch yar, it working perfectly.

Thanks,

Ashok.

Re: How to count consecutive working dates?

Anonymous — Wed, 28 Nov 2018 11:22:09 GMT

Hi,
I have a similar problem and would like to use the attached model but unfortunately I can not open the file.
Could the file be locked?
I have a valid license