topic sum of hours in QlikView

sum of hours

yoganantha321 — Wed, 25 Nov 2020 16:16:04 GMT

Guys,

When I sum worked hours of an employee for a particular month and year, I'm not getting the expected result.

Code I have used,

Hours0:

LOAD EmployeeID,

ProjectID,

ReleiveStatus,

sheet_date as Sheetdate,

worked_hours as WorkHours

Resident ResourceTimesheet;

Fact:

load Date(floor(Sheetdate),'MM/DD/YYYY') as Timesheet,

Year(Sheetdate) & '|' & Month(Sheetdate)& '|' & Date(Sheetdate) as Sheetdate,

EmployeeID,

ReleiveStatus,

If(len(WorkHours)>0,WorkHours,0) AS WorkHour

Resident Hours0;

Plz suggest a way to achieve this.

Thanks in advance.

I have attached the sample of data along with this

Re: sum of hours

sunny_talwar — Tue, 30 May 2017 14:42:24 GMT

Attached files seems to be corrupt... can you reattach may be

Re: sum of hours

yoganantha321 — Tue, 30 May 2017 15:31:38 GMT

Sunny,

I have attached the new file excel can you download it

Re: sum of hours

jtay — Tue, 30 May 2017 16:44:50 GMT

The data in your spreadsheet is showing as text. Not sure if that's a copy/paste issue or if it's a data issue. You may want to try formatting WorkHour: Num#(WorkHour,'0.0') as WorkHour