Count Of employees greater than limit time

[kakani87]

Dear All,

I need to display count of emp greater than IN time entry. vSignin as IN time variable. Any one can help me to this set expression syntax.

Following is the expression I'm using where it is not showing any error in expression view but no data returned.

=count({<tran_date={'$(=maxstring(tran_date))'},SignIn={">$(vSignin)"}>}distinct EmpName)

[Anil_Babu_Samineni]

Define that Variable please?

[tresesco]

A sample qvw with expected output stated would help us help you.

[kakani87]

Dear Anil,

Access IN time assigned to that variable

[Anil_Babu_Samineni]

Image please?

[kakani87]

Here I'm sharing a sample Data With you people

PFA

[kakani87]

In the above sample i want to display the count of emp greater than the IN time value set by the user  as on calendar date

=count({<tran_date={'$(=maxstring(tran_date))'},SignIn={">$(vSignin)"}>}distinct EmpName)

[kakani87]

Dear Tresesco ... shared a Sample file so coluld you check once

[kakani87]

Dear Anil .... shared a Sample file so coluld you check once

[tresesco]

Try like:

=Count({<SignIn={">$(=time(vSignin,'hh:mm:ss'))"}>}DISTINCT EmpName)