term sum or count

[#1]

Hello to all

I am a beginner in QlikView, I try to make a qw report is based on a path of personal drive (time of entry, time out, areas, etc..).

I am looking for a formula (expression) that will allow me to count the number of times an individual is late from 7am 45

I can retrieve all day from late this expression:

=if((CalendarWeekDay = 'Monday' or  CalendarWeekDay =' Tuesday ' or CalendarWeekDay =' Wednesday ' or  CalendarWeekDay =' Thursday ' or CalendarWeekDay =' Friday')) and min((hours),1)>=maketime(7,45),min((hours),1))

name	Service	Date	Semaine	month	day	Hours Arrival
agent 5	INFORMATIQUE	04/02/2014	6	February	Tuesday	07:56:08
agent 7	INFORMATIQUE	04/02/2014	6	February	Tuesday	07:52:20
agent 1	INFORMATIQUE	03/02/2014	6	February	Monday	08:37:58
agent 1	INFORMATIQUE	04/02/2014	6	February	Tuesday	08:15:14
agent 1	INFORMATIQUE	05/02/2014	6	February	Wednesday	08:38:14
agent 1	INFORMATIQUE	06/02/2014	6	February	Thursday	08:20:36
agent 4	INFORMATIQUE	03/02/2014	6	February	Monday	07:45:54
agent 4	INFORMATIQUE	07/02/2014	6	February	Friday	07:50:46
agent 6	INFORMATIQUE	05/02/2014	6	February	Wednesday	13:23:36
agent 6	INFORMATIQUE	07/02/2014	6	February	Friday	15:38:20
agent 2	INFORMATIQUE	03/02/2014	6	February	Monday	07:49:18
agent 2	INFORMATIQUE	04/02/2014	6	February	Tuesday	07:49:12
agent 2	INFORMATIQUE	05/02/2014	6	February	Wednesday	08:03:18
agent 2	INFORMATIQUE	06/02/2014	6	February	Thursday	08:08:40
agent 2	INFORMATIQUE	07/02/2014	6	February	Friday	07:58:28
agent 3	INFORMATIQUE	04/02/2014	6	February	Tuesday	08:00:26

Now my problem is how can we have the sum of all minimum an agent or counting to get a result like that.

agent 1 = 4

agent 2 = 5

agent 3 = 1

agent 4 = 2

agent 5 = 1

agent 6 = 2

agent 7 = 1

[#2]

if I create a simple table with user id how I will use the term count
count ({$ <FLAGLATE = {1}} FLAGMINHOURS)

[maxgro · Accepted solution]

add a tablebox using Table and verify if the records you wants are flagged

if yes build the chart using the expression in my attachment (modified because of different source data);

dimension     idusager

expression     count({$ <FLAGLATE={1},FLAGMINHOURS={1}>} DISTINCT date)

[#4]

thank you it works well

[maxgro]

Please close this discussion by giving Correct and Helpful answers to the posts which are useful for you.  It helps others in finding answers for similar scenarios.