topic Re: Set expression Issue in count of emp in QlikView

Set expression Issue in count of emp

kakani87 — Mon, 08 Jan 2018 13:32:42 GMT

Hi Everybody,

displayed sample data app it is showing access details of an employee IN and OUT with Total time spent

Now want to display the count for red colour highlited rows of emp like count of IN time in red it is displayed properly but like that OUT and Timespent count as well to displayed. EXPRESSION for IN considering as

=Count({<EmpName={"=Min({<tran_date = {$(=Num(Max(tran_date)))}>} SignIn)>$(vSignin)"},tran_date={'$(=maxstring(tran_date))'}>}DISTINCT EmpName)

Kindly help me with this.

Regards,

Kakani.

Re: Set expression Issue in count of emp

Anil_Babu_Samineni — Mon, 08 Jan 2018 13:41:34 GMT

PFA

Re: Set expression Issue in count of emp

kakani87 — Mon, 08 Jan 2018 13:47:23 GMT

Anil Thank you for the support.

Re: Set expression Issue in count of emp

kakani87 — Mon, 08 Jan 2018 13:55:04 GMT

Anil Time spent in HRS is showing wrong data.

Here I'm sending you the Attachment Kindly check this TIMESPENT COUNT.

Re: Set expression Issue in count of emp

Anil_Babu_Samineni — Mon, 08 Jan 2018 14:05:02 GMT

May be this?

=Sum(Aggr(If((Max({<tran_date = {"$(=Num(Max(tran_date)))"}>} SignOut) - Min({<tran_date = {"$(=Num(Max(tran_date)))"}>} SignIn))<'08:00:00',1,0), tran_date, EmpName))

Re: Set expression Issue in count of emp

kakani87 — Mon, 08 Jan 2018 14:11:13 GMT

This is Correct Anil.