topic Re: Script help in QlikView

Script help

Tue, 11 Mar 2014 11:46:38 GMT

Hello All,

I am working on Attendance Tracking system.

And want to find such employees who are Absent for 7 or more consecutive days.(Working days)

I have the following fields in it.

Empid,Date,Status

Status has the values as Present,Absent.Off

How do I proceed to get a solution.

Thanks and Regards,

Priya

Re: Script help

jsingh71 — Tue, 11 Mar 2014 11:52:49 GMT

Can you upload some sample data.

Re: Script help

MK_QSL — Tue, 11 Mar 2014 11:54:25 GMT

Can you load your sample data file?

Re: Script help

Tue, 11 Mar 2014 12:06:47 GMT

Hello All,

Pls Find the sample data.

Thanks & Regards,

Priya

Re: Script help

jonathandienst — Tue, 11 Mar 2014 12:15:15 GMT

You need something like this:

Load your existing data:

Data1:

LOAD EmpID,

Date,

Status,

...

FROM .....;

Now load from the Data resident

Data2:

LOAD *,

If(EmpID = Previous(EmpID),

If(Previous(Status) = 'Absent' And Status = 'Absent',

Peek('ConsecutiveAbsentDays') + 1,

If(Status = 'Absent', 1, 0)

) As ConsecutiveAbsentDays

Resident Data1

ORDER BY EmpID, Date;

Finally drop the first Data table:

DROP Table Data1;

Now you can create an straight table object with Dimension EmpID and expression If(Max(ConsecutiveAbsentDays) >= 7, 'Absent > 7 Days') and ensure that suppress 0 and suppress missing options are on

HTH

Jonathan

Re: Script help

Tue, 11 Mar 2014 12:33:50 GMT

Try the attached.