Variable

[gautik92]

I want to create variable for yesterday and i want to count no of employees present yesterday using that variable

[qlikmsg4u]

Use this to create Yesterday variable

Let vYesterday = Date(Today()-1)

TO count no of employees use this

=Count({<YourDateField = {'$(vYesterday)'}>} Distinct EmpID)

[gautik92]

that is ok  but how can use variable in count expr

I want to find no of employees present yesterday

[qlikmsg4u]

=Count({<YourDateField = {'$(vYesterday)'}>} Distinct EmpID)

[tresesco]

vYesterDay = Date(Today()-1)

Count(Distinct {<Date={'$(vYesterDay)'}>} Employees)

[Peter_Cammaert]

To supply you with a ready-to-use expression, we need to know more about the table in which you keep employee presence information.

You can use this as an example (set analysis):

=Count({<RecordDate = {"$(vYesterday)"}>} DISTINCT EmployeeID)

[Peter_Cammaert]

Shouldn't distinct go after the set analysis spec?

[maxgro]

expression

count({$ <Date={'$(vYesterday)'}>} IdEmployee)

variable vYesterday

=date(today()-1)

or

=(today()-1)

[Kushal_Chawda · Accepted solution]

Create variable in front end

vYesterday = date(max(YourDateField)-1,'YourDateFormat')

Now use below expression to count the employees

=Count({<YourDateField= {'$(=vYesterday)'}>} EmpID)

Without variable you can use below expression

=Count({<YourDateField= {'$(=date(max(YourDateField)-1))'}>} EmpID)

[tresesco]

Hi Peter,

It actually works both ways.