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: 
Not applicable

How to count consecutive working dates?

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.    

1 Solution

Accepted Solutions
tresesco
MVP
MVP

May be like attached sample.

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

View solution in original post

4 Replies
tresesco
MVP
MVP

May be like attached sample.

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

er_mohit
Master II
Master II

@See the attached file

Not applicable
Author

Hi Tresesco,

Thank u somuch yar, it working perfectly.

Thanks,

Ashok.

Anonymous
Not applicable
Author

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