Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
kakani87
Specialist
Specialist

Count Of employees greater than limit time

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)

1 Solution

Accepted Solutions
tresesco
MVP
MVP

I guess you are trying to count the employees with RED highlighted condition satisfied, if so, try:

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

View solution in original post

19 Replies
Anil_Babu_Samineni

Define that Variable please?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
tresesco
MVP
MVP

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

kakani87
Specialist
Specialist
Author

Dear Anil,

Access IN time assigned to that variable

Anil_Babu_Samineni

Image please?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
kakani87
Specialist
Specialist
Author

Here I'm sharing a sample Data With you people

PFA

kakani87
Specialist
Specialist
Author

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
Specialist
Specialist
Author

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

kakani87
Specialist
Specialist
Author

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

tresesco
MVP
MVP

Try like:

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