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))
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