Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

expression to count number of entries per day

Hi,

I have a script that outputs the times an employee swiped per day.

There will be a report that outputs details per day per week.

I am having an issue with writing an expression to count the number of clockings made per particular day.

Using the count function count(fieldname) but Im not sure what to do about the number of entries (clocking times) per user per day? Its the per user per day part that I am struggling with.

Thanks,

Gregg

10 Replies
jagan
Partner - Champion III
Partner - Champion III

Hi,

I think you want to display the Time(HH:MM:SS) when the Person swiped, for this use this expression

=Concat(Time, ',')

as another expression

Hope this helps you.

Regards,

Jagan.