Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
ali_hijazi
Honored Contributor

get the first and last day of a month in a specific year

Hello

I have the following task to be implemented

I have an excel sheet in which each employee has the date and time on which the (s)he came into the office and left

I want to calculate the total number of hours each employee spent in the office per month and display this info on a chart

what I'm thinking of is calculate the number of hours per day then get the total group by month

so what I need here is to know the first day and the last day of a month specified by the user from an input object so that I know the range of date to calculate the total number of hours ; plus I appreciate if you supply me with date and time functions

3 Replies
perumal_41
Valued Contributor II

Re: get the first and last day of a month in a specific year

please check

Not applicable

Re: get the first and last day of a month in a specific year

if([Date]=Date(Floor(MonthEnd([Date]))),1,0) as end_Flag,

Not applicable

Re: get the first and last day of a month in a specific year

Why dont you just subtract the exit time from the time the employee came into work. Im assuming the entry and corresponding exit time will be on the same row.

You could very easily do this on the script. Then sum the daily hours on a straight table

Community Browser